Run a macro when a worksheet is executed?

  • Thread starter Thread starter raraujo
  • Start date Start date
R

raraujo

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

Thanks

Rubens Araujo

(e-mail address removed)
 
raraujo


there are 2 ways

1st in a normal module have a macro

sub Auto_Open

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
 
mudraker,

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

Thanks

Ruben
 
Back
Top