Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing hidden sheets with vba. | Excel Programming | |||
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets | Excel Programming | |||
Printing a hidden sheet | Excel Programming | |||
Printing hidden sheets | Excel Programming | |||
Code for Printing Hidden Sheets | Excel Programming |