printing hidden sheets
Modify to Suit:
Sub printHidden()
Application.ScreenUpdating = False
Worksheets("Sheet1").Visible = True
Worksheets("Sheet1").PrintOut
Worksheets("Sheet1").Visible = False
Application.ScreenUpdating = True
End Sub
--
Jay
"SmartyPants" wrote:
I need some VBA code, for a button, that will allow me to print sheets
that I have hidden.
Or if there is any other way to set up a button to do this...
Any help would be appreciated.
|