print sheets

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

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?
Click to expand...

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
 
Back
Top