Printing in Excel

[jimewood]

I am using PrintOut to print selective worksheets based on user input. Can I avoid the sheet being printed from viewing on the screen?

[Ivan F Moala]

On 2002-05-16 15:04, jimewood wrote:
I am using PrintOut to print selective worksheets based on user input. Can I avoid the sheet being printed from viewing on the screen?

Hi jimewood Welcome, if I understand your Q
then you have code to print out variouse
sheets that you select via user input ?

If you don't wnat them to display then
place this code before you Print;

Application.screenupdating=false

'

'

'

'your print code

'

'

'

Application.screenupdating=true

End Sub

[stevebausch]

I think you may be fighting a losing battle on this. I just set up a test macro to confirm what I have experienced while developing a workbook over the past 9 months.

You cannot print a hidden sheet in Excel-97, OR Excel 2002. I just checked. So that idea is out.

I have a rather complex workbook that shuffles output to three different printers, printing to a laser printer, and two label printers, one with large, one with small labels. One click, and off it goes.....

Application.ScreenUpdating is set to False, and I can still the various worksheets flickering in the background, behind the form.

You may need to toss up a blank userform, if you want to mask what is going on "behind the scenes".

I could make my userform a bit bigger, and that would conceal.

I just tell myself "Hey, Excel is one hell of a spreadsheet program, if the only thing that bothers me is a bunch of worksheets flickering and flashing in the background while printing, I need to reassess my priorities."