message/dialog box auto open when excel file is activated
 

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

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
HIS


"welshwizzard" wrote in message
...
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

many thanks.
Welshwizzard




..
"Nick Hodge" wrote:

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
HIS


"welshwizzard" wrote in message
...
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