Bill Youngman

Posts: n/a

Thanks JF - that worked like a charm

wrote in message
ups.com...
Hi Bill,

Use:
Application.ScreenUpdating = False
When you want the screen to 'freeze', and:
Application.ScreenUpdating = True
to set it back to normal.

Cheers,
JF.

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
how to lock worksheet formatting?	TANDEX	Excel Worksheet Functions	3	May 11th 05 10:22 PM
How to lock worksheet formatting?	TANDEX	Excel Worksheet Functions	1	May 6th 05 09:36 PM
xls worksheet formatting a single cell	Archer------------>	Excel Discussion (Misc queries)	1	April 30th 05 07:25 PM
Why color formatting not showing on worksheet?	Mary-Lou	New Users to Excel	2	March 9th 05 10:17 AM
Formatting a worksheet for data entry	DV in Texas	Excel Worksheet Functions	2	March 6th 05 07:48 PM

All times are GMT +1. The time now is 04:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us