Hide screen while Macro is working

[DJK]

I have a template with 16 different forms. There are 16 buttons and when the
user double clicks on a button, all other forms are cut leaving only the form
they need. This works very well but the flashing screen is annoying. Is
there a way not to hide this macro working screen?
DJK

 

[Bear]

DJK:

Try putting

Application.ScreenUpdating = False

at the start of your macro, and

Application.ScreenUpdating = True

at the end of the macro.

Bear

 

[DJK]

IT WORKS!! - THANK YOU SOOOO MUCH!