LadyG
08-07-2018, 08:01 AM
Hi,
I have 5 macros that should run when opening a workbook however I receive a runtime error 1004. Cannot run the macro. The macro may not be available in this work book or all macros may be disabled. Macros are available and enabled in settings.
Private Sub Workbook_Open()
'Run ("RefreshPivotTables")
'Run ("COuntSites")
'Run ("MyCopySaveRv")
'Run ("CopyAnalysis")
'Run ("MyMacro22")
End Sub
Any help would be greatly appreciated.
Thanks
LadyG
I have 5 macros that should run when opening a workbook however I receive a runtime error 1004. Cannot run the macro. The macro may not be available in this work book or all macros may be disabled. Macros are available and enabled in settings.
Private Sub Workbook_Open()
'Run ("RefreshPivotTables")
'Run ("COuntSites")
'Run ("MyCopySaveRv")
'Run ("CopyAnalysis")
'Run ("MyMacro22")
End Sub
Any help would be greatly appreciated.
Thanks
LadyG