Hi,
Does anyone know if it's possible to have a Personal Macro Workbook do certain steps whenever a file is opened or closed? For example, if I opened a file, I'd like the Personal Macro workbook to automatically start up and do some stuff. Then when I close the file, I'd like the Personal Macro Workbook to again do some more stuff, save the file and then close it. I'd like this to happen without the user having to click any buttons or keystrokes.
I experimented with Auto_Open and Auto_Close, but since that's tied to the Personal Macro Workbook it only works when the Excel program is either started up or shut down.
Thanks for looking at my questions.
Jay
Bookmarks