Thread: AutoExec
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nikos Yannacopoulos[_3_] Nikos Yannacopoulos[_3_] is offline
external usenet poster
 
Posts: 1
Default AutoExec

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. )
-----Original Message-----
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 Auto_Open modul and
a different Modul with a "Sub Auto_Open()" in
it.

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

Best Regards George


.