Displaying just egg timer when running long multisheet macro

[01491]

I have a VBA code that does various editing functions over multiple worksheets. I am looking for a piece of code that displays just the opening sheet with an eggtimer instead of having the strobe effect from swapping from page to page.

Any offers?

Thanks.

 

[JustinEzequiel]

try setting the ScreenUpdating property of the Excel Application? to false

 

[01491]

Sorry,

I'm not quite sure what you mean.

Is this VBA code or an option from the menu.

Thanks.

 

[JustinEzequiel]

"I have a VBA code that does various editing functions over multiple worksheets."
Assuming from your statement above that you have a macro that does whatever, then try adding [tt]Application.ScreenUpdating = False[tt] before any actual processing

[tt]
Sub YourProcedure()
Application.ScreenUpdating = False
Application.Cursor = xlWait

' rest of your code goes here

Application.Cursor = xlDefault
Application.ScreenUpdating = False
End Sub
[/tt]

 

[01491]

Perfect!!

Thanks.