Hello,
I have a macro which uses application.ontime.
When it runs, Excel's Control+Y (F4) feature stops working. This feature is required by users of the macro.
The macro runs fine and users can carry on working while it runs. There is just one specific issue I need to address.
The problem is that, while the macro is running, the user is unable to use the Control+Y (F4) feature to repeat the last operation. I'm looking for a way round this limitation; so users can be running the macro in the background, perform an operation and user control-Y whenever they want to.
I need someone to return this same worksheet to me so that when I run the macro, I can perform an operation on one cell, move to another cell and type Control-Y to repeat that last operation (while the macro is still running and before the timeout).
Thank you!
Reply With Quote
