| 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 | |||
Hybrid Mode
