PDA

View Full Version : Sleeper: Hide VBA operations



AlexGravel
05-12-2010, 12:24 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

GTO
05-12-2010, 01:01 PM
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
05-12-2010, 01:15 PM
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