View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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.