Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I print hidden Excel worksheets?
I've set up macros to print specific areas of hidden worksheets. I'd like to
be able to use the macro while keeping the sheets hidden. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I print hidden Excel worksheets?
Not sure if you can print sheets while they're hidden, but one
possible work-around would be to set ScreenUpdating to False, un-hide the sheet print what you want re-hide the sheet set ScreenUpdating to True Post your code for further assistance.... ray |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I print hidden Excel worksheets?
You cannot print from a hidden sheet. Do what Ray suggests. HTH Otto
"Ned C." <Ned wrote in message ... I've set up macros to print specific areas of hidden worksheets. I'd like to be able to use the macro while keeping the sheets hidden. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I print hidden Excel worksheets?
Actually, you don't even HAVE to turn screenupdating off - you'd be on some
other sheet when you performed the print of the sheet, and not even change view for long - there might be a flicker as the sheet is unhidden, printed, rehidden. But to prevent the flicker, turning it off is a nice touch. Sub PrintMyHiddenSheet() Application.ScreenUpdating = False Sheets("myHiddenSheetName").Visible = xlSheetVisible Sheets("myHiddenSheetName").PrintOut Copies:=1, Collate:=True Sheets("myHiddenSheetName").Visible = xlSheetHidden Application.ScreenUpdating = True End Sub "Ray" wrote: Not sure if you can print sheets while they're hidden, but one possible work-around would be to set ScreenUpdating to False, un-hide the sheet print what you want re-hide the sheet set ScreenUpdating to True Post your code for further assistance.... ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Hidden worksheets | Excel Worksheet Functions | |||
how to print hidden column in excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
How do I print only the hidden worksheets in a workbook? | Excel Discussion (Misc queries) |