[RESOLVED]Excel-Triggering Personal Workbook BeforeSave event with any open workbook?

[davidd31415]

Hi,

I wrote BeforeSave event handler in my Personal Workbook that runs Excel's spellchecker. My goal is to ensure that I do not forget to spellcheck spreadsheets. I was pleased to see that the "spell check complete" dialog doesn't appear when there are no spelling errors in this case, however...

The Personal Workbook's BeforeSave event is only triggered when the Personal Workbook is saved; I can see why this is...

Now I'm looking for a way to accomplish my original goal, any suggestions?

If there is a way to have the Personal Workbook copy the procedure into other opened workbooks when it/they are opened... I'd be interested to know HOW that is done, it sounds like the most difficult approach though.

I've thought about saving an file and trying to use it as a template... Perhaps templates are my best answer, I haven't worked with those much.

Finally, I do not know many details about the network that I am on but I use several different computers on it. Off topic, but if there is a method to use a single Personal Workbook macro across a network (XP), let me know.

Thanks all,

David.