PDA

View Full Version : Sheet PrintOut Halt



wnick
03-13-2008, 05:05 AM
Hi

I don't understand why a printing is halted when
PrintOut method is called for Sheet Object like this:

Sheet.Application.ScreenUpdating = True
Sheet.Select
Sheet.PrintOut

Nick

shades
03-13-2008, 12:22 PM
Howdy, and welcome to the board.

Is this specific to a Mac version of Excel? If so, which version?

wnick
03-14-2008, 01:25 AM
No, I use MS Excel 2003, and I have halting problem with printing sheets of one excel file, but for many other files they are printed ok

tpoynton
03-14-2008, 11:48 AM
this is the mac forum for mac-specific questions! you'd be better off posting in the Excel help forum.

no need to qualify application.screenupdating with sheet; try removing that, although it doesnt sound like it will help.

shades
03-17-2008, 08:52 AM
I have moved this thread to Excel Help, since it is not Mac specific.