Not ScreenUpdating with PrintOut Property

Posted to microsoft.public.excel.programming

Edd[_2_]

external usenet poster

Posts: 22

Not ScreenUpdating with PrintOut Property

Hello:

I use ActiveWindow.SelectedSheets.PrintOut in my code, and this code
seemingly freezes my code in-action from being viewed on the screen. It
reacts similarly to when Application.ScreenUpdating is set to false (and it
is not). When I press on the Print smarticon, all works as intended. How can
I disable the screen from freezing when I use
ActiveWindow.SelectedSheets.PrintOut or do you have any suggestive
work-arounds?

Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Property value of class instance by passing string property name	[email protected]	Excel Programming	2	October 19th 07 05:47 PM
Runtime error 380 - Could not set the list property. Invalid property value.	[email protected]	Excel Programming	3	February 27th 07 06:35 AM
Runtime Error 380 – Could not set the list property. Invalid property value	BernzG[_16_]	Excel Programming	2	August 21st 05 10:10 PM
Runtime error 380: Could not set the List property. invalid property value of listbox	jasgrand	Excel Programming	0	October 6th 04 09:28 PM
Is there a Filename property in PrintOut property	Christian[_6_]	Excel Programming	4	September 3rd 04 10:12 PM

All times are GMT +1. The time now is 01:14 PM.

Menu

About Us