Excel 2003 - Compile Error - Invalid Outside Procedure
Please Help! This is my first attempt at setting up a Macro in Excel 2003 and all I want to do is print out 8 worksheet pages with a macro.
The first message I get says: "Unable to Record" Then I click on "OK" and it records the key strokes anyway! However, when I try to run it, I end up with that Compile Error Message. Thank you in advance for your assistance. Here is the Macro:
Sub PrintALLpgs()
'
' PrintALLpgs Macro
' Macro recorded 2/16/2009 x XXXXX
'
' Keyboard Shortcut: Ctrl+Shift+P
'
Sheets("Cover").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Energy").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Equip").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Repairs").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Major").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("In-House").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Summary").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Notes").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub