Hiding operations with VBA

AlexGravel
05-12-2010, 01:35 PM
Hi everyone,
I am trying to hide the operations of a vba code that hides and unhides worksheets on my document. When I hit the button related to my vba code the worksheets I am unhiding come flying on the screen (kind of flashing ) before they are all there. Is there any code I could write in order to hide the operations?
Thank you

Colin Legg
05-12-2010, 01:44 PM
Hi and welcome to the forum. :)

Have a look at the Application.ScreenUpdating property in your Excel VBA helpfile.

Hope that helps...

AlexGravel
05-12-2010, 01:49 PM
Thank you very much!
application.ScreenUpdating=False solves my problem

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum