I have the below macro in the workbook startup to ask if I want to run the macro in the workbook.
Private Sub Workbook_Open()
CarryOn = MsgBox("Do you want to run the Macro?", vbYesNo)
If CarryOn = vbYes Then
Application.Run Macro:="holding2"
End If
End Sub
After I click "YES" it tells me the...