EXCEL macros with Windows and MacOs

Question

I have an Excel file that several colleagues share.

On windows the file macros work perfectly but on Mac systems they don't. (Windows macros detect them but not on Mac)

I leave the macro below:

Sub AfegirSilla() 

 

    Dim Pregunta As String 

     

    Application.Goto Reference:="tSilla" 

    Selection.End(xlDown).Select 

 

    Pregunta = MsgBox( _ 

    "¿Añadir una fila vacía al final de la tabla de SILLAS?", _ 

    vbYesNo + vbQuestion, "S I L L A S") 

 

    If Pregunta = vbNo Then 

        Exit Sub 

    End If 

 

    ActiveSheet.Unprotect 

    Selection.ListObject.ListRows.Add AlwaysInsert:=True 

         

    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, _ 

    AllowSorting:=True, AllowFiltering:=True 

     

    ActiveCell.Offset(1, 0).Select 

     

End Sub 

Sub AfegirAlumne() 

 

    Dim Pregunta As String 

     

    Application.Goto Reference:="tAlumno" 

    Selection.End(xlDown).Select 

 

    Pregunta = MsgBox( _ 

    "¿Añadir una fila vacía al final de la tabla de ALUMNOS?", _ 

    vbYesNo + vbQuestion, "A L U M N OS") 

 

    If Pregunta = vbNo Then 

        Exit Sub 

    End If 

 

    ActiveSheet.Unprotect 

    Selection.ListObject.ListRows.Add AlwaysInsert:=True 

         

    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, _ 

    AllowSorting:=True, AllowFiltering:=True 

     

    ActiveCell.Offset(1, 0).Select 

     

End Sub

Answer 1

It doesn't give me any errors, it just doesn't detect the macro, I have the Mac shortcut of cmd ctrl + shift + A.

In windows it detects the macro without any problem and I can execute it. in macos i can't run.

Answer 2

You shouldn't count on VBA on mac...
Regards.