Code would have to be in a workbook that is opened when Excel opens.
Choices would be
Personal.xls
an addin that will be loaded
Other workbook in the xlstart directory.
Then the workbook_Open event would have to trigger the code you have
written.
If Excel is opened programmatically via automation, non of these files would
be loaded by default.
To establish this environment, you would need the user to run some type of
install routine.
--
Regards,
Tom Ogilvy
"John Davidson" wrote in message
...
I have code to register my class module what I need to do is cause this
code to execute when Excel starts up sort of like a autoexec.
{John}
"Tom Ogilvy" wrote in message
...
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.