Popup MsgBox When Workbook Opens

Topic

New Reply

One of my customers would like a message box to pop up as soon as she opens a certain workbook reminding her that she needs to open another workbook as well.

I’ve looked at the App_WorkbookOpen procedure but can’t make it work.

Can anybody help me?

Thanks in advance,

Christa

Reply | Quote

Replies

Maybe, this might help (look in the ThisWorkbook module to find the workbook_open event):

Private Sub Workbook_Open()
   MsgBox "Hello! Just to remind you that you have to open another workbook! Thanks!"
End Sub

Reply | Quote

Thanks! It worked.

Reply | Quote