screen flicking
Hi all,
I've got a macro which searches one sheet and copies a particular value to a new sheet. There's alot of information and therefore when the macro runs the screen flicks. Is it possible to show a blank sheet while the macro runs so that the user doesn't see whats happening? thanks in advance mike |
screen flicking
Hi Mike,
At the beginning of your macro put: Application.ScreenUpdating=False then at the end of the macro put: Application.ScreenUpdating=True Regards, Z "mike" wrote: Hi all, I've got a macro which searches one sheet and copies a particular value to a new sheet. There's alot of information and therefore when the macro runs the screen flicks. Is it possible to show a blank sheet while the macro runs so that the user doesn't see whats happening? thanks in advance mike |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com