Macro at Startup

[JTL9161]

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 macro is not available. Its a separate module in the same spreadsheet. Is there another way to run it or do I need to move all my code over to the workbook startup and all under the msg book question code?

Thanks
James

 

[Fluff]

Try using

Call holding2

 

[JTL9161]

Now I do not even get the message box. I get "Expected Variable or procedure, not module" error

 

[Fluff]

What is the name of the macro you are trying to run?

 

[JTL9161]

Holding2

 

[Fluff]

What is the first line of the sub where the name is?

 

[Joe4]

Can you please your entire "Holding2" code block?
Also, which module is this code found in?