Forum Discussion
Solved
VBA Macro Error with application.ontime
Hello everyone, I am having an issue getting a macro to run while using application.ontime. The macro itself works if i call it alone, but i get the error (Attached Snip) stating that the macro is...
Are you sure that the macro NoTouch is stored in a standard module (the kind you create by recording a macro or by selecting Insert > Module in the Visual Basic Editor) in the same workbook? It won't work if NoTouch is stored in a worksheet module or in the ThisWorkbook module.
Are you sure that the macro NoTouch is stored in a standard module (the kind you create by recording a macro or by selecting Insert > Module in the Visual Basic Editor) in the same workbook? It won't work if NoTouch is stored in a worksheet module or in the ThisWorkbook module.
I do not have time to try right now because of training today, but I do know that it is in a worksheet, and not one that I created. I will try to move it when I get out of training. Thank you.