Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code
I have some VBA code that loops thru sheets and protects
them (or unprotects dependant on a variable). Unfortunately, everytime it runs- excel thumbs thru the sheets and you can see the process happen (similar to if I recorded a macro). Most of the time the code happens in the background without visibly thumbing thru sheets, is there a way to hide what the code is doing in this particular case or does it need to have the sheet activated in order to protect it? BTW- I hope I'm not abusing this forum by asking too many questions :| They've just been building up and now I have a place to get them answered thnx in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code
Add the following line at the beginning of your macro
Application.screenupdating = false No movement will be seen when you run the macro I don't think anyone minds how often you post. The main thing is to make sure your questions are easily understood. If necessary post sample data to explain what you are doing but NEVER, NEVER, NEVER attach spreadsheets as they will be ignored by most readers DavidP On Fri, 7 Nov 2003 22:09:10 -0800, "DJ" wrote: I have some VBA code that loops thru sheets and protects them (or unprotects dependant on a variable). Unfortunately, everytime it runs- excel thumbs thru the sheets and you can see the process happen (similar to if I recorded a macro). Most of the time the code happens in the background without visibly thumbing thru sheets, is there a way to hide what the code is doing in this particular case or does it need to have the sheet activated in order to protect it? BTW- I hope I'm not abusing this forum by asking too many questions :| They've just been building up and now I have a place to get them answered thnx in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code
And don't forgrt to set it back to "True" when you're finished or, as I
found out, it becomes very interesting!. -- Regards; Rob Please reply to the NG I'm already up to my eyeballs in Nigerian/South African get rich letters as well as "Microsoft Critical Updates" et al. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |