Is there an event that is called as soon as we open an excell doc? 1

[Fursten]

HI again

Is there an event to excell like "initialize", that is called as soon as we open the document?

Thank you again.

 

[ilses]

Hi Silvio,

The ThisWorkbook has a standard procedure:
Private Sub Workbook_Open (you can select it from the dropdown boxes).

For an add-in Autpen can be used.

Ciao,

IS

 

[dodgyone]

Both of these options work but when I change to another sheet then this suotmatic procedure also runs with it.

How can I run the procedure only once at start-up?

Thank you...

 

[dsi]

Use the Autpen sub in a project module, not in the sheet object (Insert > Module). This should tie the code to the workbook, not the individual sheets.