Run a macro when a worksheet is executed?

[raraujo]

Do anybody knows how can I execute automaticaly a macro when a workshee
is opened.

Thanks

Rubens Araujo

(e-mail address removed)

 

[mudraker]

raraujo


there are 2 ways

1st in a normal module have a macro

sub Autpen

msgbox "Hi - From Auto Open Macro"

end sub


2nd method in the ThisWorkbook Module

Private Sub Workbook_Open()

Msgbox "Hi - From Workbook_Open event"

End Sub

 

[raraujo]

mudraker,

Please, could you explain how I insert this subrotines in the workshee
?

Thanks

Ruben

 

[Norman Harker]

Hi Rubens!

David McRitchie has two pages that are well worth visiting to cover
what you need.

Start here:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Then go on to:
http://www.mvps.org/dmcritchie/excel/event.htm