Hi Guys,
Quick question...
I have a macro used on a shared network drive that auto saves the file after a set time, and closes the activeworkbook.
The user also has a macro to save and exit the file.
Can somebody tell me what code I can use to stop the macro running when the user clicks to close - or what code I use to close excel (program not activeworkbook).
Thanks
Quick question...
I have a macro used on a shared network drive that auto saves the file after a set time, and closes the activeworkbook.
The user also has a macro to save and exit the file.
Can somebody tell me what code I can use to stop the macro running when the user clicks to close - or what code I use to close excel (program not activeworkbook).
Thanks