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
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
Howdy, and welcome to the board.
Is this specific to a Mac version of Excel? If so, which version?
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
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
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.
I have moved this thread to Excel Help, since it is not Mac specific.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich