event procedure

[JIM.H.]

Hello,

I could not really understand this part yet but I am using
this event in a module and I want when the excel file is
open it should be launched.

Private Sub Workbook_Open()
MsgBox ("worksheet is activated")
End Sub

Thanks,
Jim.

 

[Frank Kabel]

Hi Jim
just put this in your workbook module (double click on 'ThisWorkbook'
in the VBA project explorer window). For more about event procedures
have a look at
http://www.cpearson.com/excel/events.htm

 

[JIM.H.]

Hi Frank, it works fine thanks. However, if I had this
in 'ThisWorkbook' and want to open file for macro
modification, not for run, how can I do that?
Thanks,
Jim.

 

[Frank Kabel]

Hi
not quite sure what you mean, sorry

 

[Steve Garman]

To prevent macros from automatically running, hold down SHIFT while you
start Excel

 

[JIM.H.]

It is strange but shift does not stop macro from running.
It still runs and exit.