I have a lengthy macro and made a button to click on to run it. It takes two seconds to run.
I thought it would be clever to call the macro from the activate event of the worksheet tab, so users wouldn't even have to click on the macro button. But it takes 42 seconds to run when the sheet is activated!
That doesn't seem right, does it
Macro on Sheet Tab Very Slow
klahking
Hi XLBill,
You wouldn't have thought so but putting a macro into the Activate event might cause a delay as there might be other processing going on within Excel. The sheet may be re-calculated for example. If you have a lot of data then this would need more processor which would delay your macro's run time. Not saying that's what is happening but it could be the reason,