Sometimes it is necessary in code to switch off ScreenUpdating to speed things up & prevent "screen flickers". It is also useful to switch off Calculation to speed things up.
This code will capture the user's current settings & replstore them after the code has run,
Please Login or Register to view this content.
Last edited by royUK; 05-16-2008 at 02:25 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Roy, you forgot to reverse the properties and variables when restoring you code.
Please Login or Register to view this content.
And to turn things off before executing user code?
Just checking if anyone read this(LOL)
Thanks Andy & shg, I copied & pasted from the VBE & didn't notice that the second copy hadn't picked up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks