I have this simple macro in the Personal worksheet and it works fine when run.
I then put this macro into the Open Macro I want to use when opening the file
'msgbox testing
Sub messageBox()
MsgBox ("Ok to here")
End Sub
Here is the open macro.
Private Sub Workbook_Open()
'this macro is to unprotect and show all sheets
'Sub Open_Setup()
'Call UnProtectAllSheets
'Call UnhideVeryHiddenSheets
'Call Switch_to_Quote
'Call Unhide_AD_and_AE
Call messageBox
End Sub
Upon opening, here is the error message I receive:
Microsoft Visual Basic for Applications
Compile error:
Sub or Function not defined
Anything that I try to call within the WorkBook Open macro to the personal workbook, will not run.
I am presuming that you can not call a macro in the Personal workbook from the open macro.
Any help is appreciated.
I then put this macro into the Open Macro I want to use when opening the file
'msgbox testing
Sub messageBox()
MsgBox ("Ok to here")
End Sub
Here is the open macro.
Private Sub Workbook_Open()
'this macro is to unprotect and show all sheets
'Sub Open_Setup()
'Call UnProtectAllSheets
'Call UnhideVeryHiddenSheets
'Call Switch_to_Quote
'Call Unhide_AD_and_AE
Call messageBox
End Sub
Upon opening, here is the error message I receive:
Microsoft Visual Basic for Applications
Compile error:
Sub or Function not defined
Anything that I try to call within the WorkBook Open macro to the personal workbook, will not run.
I am presuming that you can not call a macro in the Personal workbook from the open macro.
Any help is appreciated.