View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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.