Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print sheets
if you will look below and see my posting from yesterday
this will make more sense. i am trying to print a sheet that i do not want the user to see. i figured i cant print a hidden sheet without unhiding/print/hide. but i wrote a WorkbookOpen procedure to hide the sheet tabs so the user could not select that page anyway. so i can print it now. however, the sheet is briefly shown before printing. is there any way that this can remain out of view while it is printing. it has notes on it out of the print area, and other data and formulas to create the report. i just want the user to be able to print a sheet without it ever being shown. is there any "trick" to get around this? thanks for any help possible...spence |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print sheets
Hi Spence,
i just want the user to be able to print a sheet without it ever being shown. is there any "trick" to get around this? Why not temporarily add a blank sheet, copy the print area into it and print that? Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
print sheets
Spence
If I read you correctly, all you need to do is put: Application.ScreenUpdating=False just before the print command and: Application.ScreenUpdating=True right after. This will keep the screen locked to some view during the execution of the print command. HTH Otto "spence" wrote in message ... if you will look below and see my posting from yesterday this will make more sense. i am trying to print a sheet that i do not want the user to see. i figured i cant print a hidden sheet without unhiding/print/hide. but i wrote a WorkbookOpen procedure to hide the sheet tabs so the user could not select that page anyway. so i can print it now. however, the sheet is briefly shown before printing. is there any way that this can remain out of view while it is printing. it has notes on it out of the print area, and other data and formulas to create the report. i just want the user to be able to print a sheet without it ever being shown. is there any "trick" to get around this? thanks for any help possible...spence |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print all sheets in one print job so I can staple them | Excel Discussion (Misc queries) | |||
Print 100 Sheets | Excel Worksheet Functions | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Print Sheets in PDF | Excel Discussion (Misc queries) | |||
i made one spreadsheet but when i try to print two sheets print, | Excel Discussion (Misc queries) |