ExcelBanter - print sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - print sheets (https://www.excelbanter.com/excel-programming/284651-print-sheets.html)

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

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

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