I have a couple of macros in a workbook of mine that utilize the application.ontime feature in excel and run every 5 minutes automatically
When running by itself it works as it was designed , but if i open another file in excel and the macro from the 1st tries to run everything crashes.
Any ideas on how to make sure that a macro from one file isnt interfering with other excel files that may be open
Thanks
Rich
When running by itself it works as it was designed , but if i open another file in excel and the macro from the 1st tries to run everything crashes.
Any ideas on how to make sure that a macro from one file isnt interfering with other excel files that may be open
Thanks
Rich