View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default how can I create a pop-up message whenever a workbook is opened?

Right-click the excel LOGO (near the file menu), select View Code, enter this:
Private Sub Workbook_Open()
Msgbox "Hello, World!"
End Sub
Bob Umlas

"twiftshoeblade" wrote:

I would like to make a message appear in the form of a pop-up, like an input
or error message, whenever a workbook is opened.