Posted to microsoft.public.excel.programming

Ben[_10_]

external usenet poster

Posts: 3

Screen Updating

Hello,
If I want to stop the macro from flashing between sheets I use
Application.ScreenUpdating False and it works perfectly. However it is not
effective when I call the procedure that contains it from another procedure.
Is there a way round this. Thank you.

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
SCREEN NOT UPDATING	ub	Excel Worksheet Functions	2	March 18th 09 11:52 AM
Screen Updating	Raman325[_9_]	Excel Programming	2	June 30th 05 08:45 PM
Screen Updating	KG[_4_]	Excel Programming	0	January 16th 05 07:12 PM
Screen Updating	KG[_4_]	Excel Programming	0	January 16th 05 05:09 PM
Screen Updating	Jase	Excel Programming	1	October 23rd 03 05:05 PM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us