Thread
:
Hiding a worksheet while formatting it
View Single Post
#
3
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