Command button working invisibly

[imback2nite]

First time poster, long time reader here.
I am working on a spreadsheet with two command buttons. One button that will hide certain columns while other colums become visible. The second Command button will to the same...just vice versa. When I hit the button I see all the colums emerging and then disappearing. My question is.....Can I have the buttons work without seeing all the goings on? I mean can I hit the button and wait the second or two and NOT see what columns are disappearing and reappearing? Thanks for the help in advance!!!

 

[Fritz24]

Before the bulk of your code enter the line:

Application.ScreenUpdating = False

and before the end of the code

Application.ScreenUpdating = True

 

[imback2nite]

Fantastic!!

Works like a charm!!! Thanks!!! Now tha page doesn't bounce around making me dizzy!!!