AutoExec

[George Perchette]

Hi

I try to create a macro which runs when
excel is started.
I have tried it with - as word - a modul
called "AutoExec" and the routine "Sub Main".
I placed the xls in the XLStart-folder. It did not
work.
Then I tried it with a Autpen modul and
a different Modul with a "Sub Autpen()" in
it.

All this failed. Does anybody has an idea on
this? Thanks for any help.

Best Regards George

 

[Nikos Yannacopoulos]

You have to put your code in private sub Workbook_Open in
Personal.xls: From the VB Project Explorer select
Personal.xls / this workbook, and from the top left hand
drop down box in the editor window, where it reads
(General), choose Workbook.

Nikos Y. ([email protected])