Thread
:
How to disable screen updating for the Visual Basic Editor
View Single Post
#
3
Posted to microsoft.public.excel.programming
Charles
external usenet poster
Posts: 1
How to disable screen updating for the Visual Basic Editor
llowwelll
Try putting:
Sub Your_sub
Application.screenupdating=False
your code goes here
Application.screeupdating = True <<<<This reset screen updating whe
code is done.
HTH
Charle
--
Message posted from
http://www.ExcelForum.com
Reply With Quote
Charles
View Public Profile
Find all posts by Charles