Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print hidden sheets
I have designed a workbook containing several sheets. The sheet1 contains
all input data that will be entered by the user and other sheets are meant for giving output. The information entered in 1st sheet will be manipulated and spread across all other sheets. I do not want the user to access other sheets and disturb the formulas, formats and design. So, I want them to be hidden. However, when the user chooses to print the output, I want the hidden sheets printed directly on printer without displaying on the screen. Help Please. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print hidden sheets
someone kindly responded to your earlier post on this subject.
See if following does what you want. Sub PrinHiddenSheet() Application.ScreenUpdating = False With ThisWorkbook.Sheets(2) '<change as required .Visible = True .PrintOut Copies:=1, Collate:=True .Visible = xlHidden End With Application.ScreenUpdating = True End Sub -- jb "Ravi Kumar" wrote: I have designed a workbook containing several sheets. The sheet1 contains all input data that will be entered by the user and other sheets are meant for giving output. The information entered in 1st sheet will be manipulated and spread across all other sheets. I do not want the user to access other sheets and disturb the formulas, formats and design. So, I want them to be hidden. However, when the user chooses to print the output, I want the hidden sheets printed directly on printer without displaying on the screen. Help Please. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print hidden sheets
John, I am sorry I was not sure whether my question was posted or not 1st
time. It gave some error message 1st time which made me repost my question. Thank u for the help rendered. "john" wrote: someone kindly responded to your earlier post on this subject. See if following does what you want. Sub PrinHiddenSheet() Application.ScreenUpdating = False With ThisWorkbook.Sheets(2) '<change as required .Visible = True .PrintOut Copies:=1, Collate:=True .Visible = xlHidden End With Application.ScreenUpdating = True End Sub -- jb "Ravi Kumar" wrote: I have designed a workbook containing several sheets. The sheet1 contains all input data that will be entered by the user and other sheets are meant for giving output. The information entered in 1st sheet will be manipulated and spread across all other sheets. I do not want the user to access other sheets and disturb the formulas, formats and design. So, I want them to be hidden. However, when the user chooses to print the output, I want the hidden sheets printed directly on printer without displaying on the screen. Help Please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Print Array for hidden sheets using VBA | Excel Discussion (Misc queries) | |||
Print Array for hidden sheets using VBA | Excel Programming | |||
Print Array for hidden sheets using VBA | Excel Discussion (Misc queries) | |||
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets | Excel Programming |