Re: Open and BeforeSave events not triggering (Events different in 2007?)
Good thought! However, yes - I ran that line of code independantly to make sure it was working.
However - I am happy to let you know that it seems to be fixed. Unfortunately, I can't tell you why... I rebooted my computer while I was taking lunch, and now, when I re-open the file, it seems to be working.
Thank you very much for your time! I hate it when problems disappear without a satisfactory solution - however, I cannot deny that it is good to have it working, and know that I'm not out to lunch (despite the fact that it was fixed by my being precisely that).
My computer was downloading updates in the background - (hence the reboot over lunch) - so perhaps something there interfered with Excel's event triggering.
Thank you again;
Ben.