printing hidden sheets
 

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.

printing hidden sheets
 

Hi SmartyPants

See
http://www.rondebruin.nl/print.htm#visible

--
Regards Ron de Bruin
http://www.rondebruin.nl



"SmartyPants" wrote in message oups.com...
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.

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.