"Hide" running Macro

[brites]

Hi folks,
I have a macro that hide/unhide columns upon certain variables.
My concern is with the appearance of it... while the macro is running, columns keep "moving" across the spreadsheet... is there anyway to hide this effect and only show me the final results?

Thanx in advance!

 

[jasonb75]

Try entering

Application.ScreenUpdating = False

as the first line of your macro

JB

 

[brites]

Great!
Thats it!

Thanks!

 

[war4peace]

Don't forget to add

Application.ScreenUpdating = true

at the end of the macro. It's not really required, but it helps proper coding by pairing up on/off instructions.

 

[Smitty]

Just make sure to set it back to True at the end of the code.

 

[jasonb75]

Smitty, does setting it back to true actually serve any purpose? I've never used it, and haven't noticed any problems.

 

[war4peace]

There are two reasons why you should set it back to true when it's no longer needed:
1. It proves to be a pain when you want to test a macro step by step and you cannot see anything happening just because you forgot to re-enable screen updating.
2. It helps learning how to code "properly". It's like when you learn to write. If you forget to close a parenthesis once, nothing happens, but if you just catch the habit, that one time when you really need it will turn into a disaster.
I think about it this way:
You can start by not setting back Screen Updating to true, then you don't set Application.DisplayAlerts back to true and then you spend hours searching through your code for a problem that doesn't even exists, just because you forgot to "close the parenthesis"

 

[jasonb75]

Fair comment, I've not had that problem yet, but maybe it's just my way of doing things.

Would say I'm perfect and don't make errors but doubt you would believe me

 

[Smitty]

Smitty, does setting it back to true actually serve any purpose? I've never used it, and haven't noticed any problems.

Yes, because the VBE won't turn it back on for you. Same with EnableEvents as war4peace pointed out.