I'm trying to set up excel so that I get notified (e.g. a message pops up) whenever I start it, open a file, close a file, or exit the application.
I'm trying to do something similar to AutoNew(), AutoOpen(), AutoClose(), and AutoExit() from Word VBA.
So far, I've figured out how to get a message when I start excel. I put the following code inside of a personal.xls file in my XLStart directory.
However, I can't seem to get it to notify me when I open a file, close a file, or exit the application.
Does anyone know how to do any of those?
thanks.