I have created a button on my PC verision of excel and use the below to let the user know that the macro is going to run. When I go to the excel on the Mac the button doesn't work so on the Mac I made a similar button however I can not add code like the below to it. Can you and if so how do you assign code like the below to a mac button?

Sorry if this is blatently obvious.


Private Sub CommandButton1_Click()
Dim iReply As Integer

    iReply = MsgBox(Prompt:="Do you wish to Generate an Interpolated Navigation File?", _
            Buttons:=vbYesNoCancel, Title:="Navigation Generation")
            
    If iReply = vbYes Then
        Run "Macro1"
    ElseIf iReply = vbNo Then
       'Do Other Stuff
    Else 'They cancelled (VbCancel)
        Exit Sub
    End If
End Sub