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.
Thank you! It is small items like this that put me in check. I start to think I know a good amount, and then I pull an error like this and start to realize that I have only scratched the surface...