View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Radim Radim is offline
external usenet poster
 
Posts: 5
Default How to execute a macro automatically at startup of Excel?

Hi, Norman,
thank You very much for the answer. I tried the second alternative and it
worked, however I did not succeeded with the first one. I think that I made
everything as You wrote me but the code in Auto_Open was not executed at
startup.

But it is not so important for me now, because the second alternative works
well. Thank You.
Radim

Norman Jones pÃ*Å¡e:

Hi Radim,

If you put your macro in a standard module and call it Sub Auto_Open, it
will run when the workbook is opened.

Alternatively, you can use Workbook_Open event code.

If you are not familiar with event code, see Chip Pearson at:

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


---
Regards,
Norman



"Radim" wrote in message
...
Hi,
I would like Excel to execute some kind of initializing macro
automatically
when it starts. Does anyone of You know whether it is possible and if so,
how
to do that? Thank You in advance,
Radim