Sleeper: Hide VBA operations

[AlexGravel]

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

[GTO]

Try:

Application.ScreenUpdating = False
'...code hiding/unhiding sheets, changing cell values, 
' and anything that causes a lot of screen repainting
Application.ScreenUpdating = True

Hope that helps,

Mark

[GTO]

Greetings Alex,

I realized as I was posting that this is your first thread and you just joined. Welcome here :-) I am sure that you'll be very glad you joined, as there's just great folks here who go out of their way to be helpful. I know after being a 'lurker' for some time and finely joining a little less than two years ago, I have learned a lot that I am sure I just would not have elsewise.

Anyways, again, Welcome, and happy coding!

Mark