Message box at file open
Hall,
Do I need to use VBA for that?
Yes, you do.
From the workbook, press Alt + F11
Double click on "THisWorkbook" in the "Projects" window.
In the panel on the right, copy and paste the following:
Private Sub Workbook_Open()
MsgBox "My message"
End Sub
John
"Hall" wrote in message
...
For a particular Excel file, I want a message box to open as soon as the
file is opened.
Do I need to use VBA for that?
If yes, I'm new to VBA. Any quick pointers?
Thanks all.
|