message/dialog box auto open when excel file is activated

[Guest]

Please can anyone tell me the procedure how I can get a dialog/message box
to appear after I activate an excel file? Just like a splash screen in a
stand alone program.
Many thanks

 

[Nick Hodge]

You can either use an Auto_Open() macro in a standard module or (preferred)
a workbook_open() event like so

Private Sub Workbook_Open()
MsgBox "My Program"
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

many thanks.
Welshwizzard




..

You can either use an Auto_Open() macro in a standard module or (preferred)
a workbook_open() event like so

Private Sub Workbook_Open()
MsgBox "My Program"
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)