Posted to microsoft.public.excel.programming

Susan Lammi Susan Lammi is offline

external usenet poster

Posts: 11

unable to control screenupdating

I have some very extensive VBA Code running in Excel. I am having trouble
controling the screen updating.

It seems that anytime I open a new workbook via VBA the screenupdating
resets to True also

Running in debug I can see that sometimes the command
Application.screenupdating=false seems not to have any effect at all.

Are there any hints/tips anyone can offer.

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
about screenupdating	baha	Excel Discussion (Misc queries)	0	March 25th 10 06:16 AM
Screenupdating Problems	Trent	Excel Discussion (Misc queries)	0	April 28th 06 07:03 AM
What does ScreenUpdating = False do?	Judy Ward	Excel Worksheet Functions	5	July 9th 05 09:25 AM
Unable to add references to Calendar control and outlook object	utham raj via OfficeKB.com	Setting up and Configuration of Excel	0	February 3rd 05 09:48 AM
Application.ScreenUpdating = False	Pieter Kuyck	Excel Programming	2	July 15th 03 06:28 PM

All times are GMT +1. The time now is 02:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us