See Chip Pearson's page on Application Level events

http://www.cpearson.com/excel/appevent.htm

for writing code with code
http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"John Davidson" wrote in message
...
Folks,

I have written an event handler to to validate the work book name before
saving a work book. Ineed to know what code do I have to write to have
the
event handler register itself when Excel starts.

Also is there some install procedure where I can move my code and user
from into the personal.xls in the XLSStart directory? I can do it by hand
but that is a pain.

Thanks,

{John}

I miss Cusp and Mesa.