Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I saw this handy code on Ron Debruin's page which prints all hidden and
unhidden pages. 'Dave Peterson Dim curVis As Long Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets With sh curVis = .Visible .Visible = xlSheetVisible .PrintOut .Visible = curVis End With Next sh End Sub Is it possible to incoporate some additional code which excludes some sheets. Basically I have a report and I want to print all the pages (some hidden) except the large data dump sheet. Lets say the sheet is called 'Data'. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print question - Calling Dave Peterson! | Excel Discussion (Misc queries) | |||
Dave Peterson | Excel Discussion (Misc queries) | |||
Combo Box or Data Validation | Excel Discussion (Misc queries) | |||
Print Copy limit | Excel Discussion (Misc queries) | |||
formula not working | Excel Discussion (Misc queries) |