MrExcel Publishing
Your One Stop for Excel Tips & Solutions

keep sheets from showing


Posted by Steve on October 31, 2001 4:37 AM

I have several macros that move from one sheet to another as they run. Is there a way to keep the sheets from showing so when the macros run, only the starting sheet shows? I think all the blinking and flashing looks unprofessional.

Thanks
Steve


Posted by Barrie Davidson on October 31, 2001 6:04 AM

Use

Application.ScreenUpdating = False

Before your code begins. Be sure and insert

Application.ScreenUpdating = True

at the end of your code to turn the screen updating back on.

Regards,
BarrieBarrie Davidson