On Open

[Heather]

Can anyone tell me how I can make a message box appear
when the user opens the workbook?

Thanks!!

 

[Ron de Bruin]

Hi Heather

See Chip Pearson his page about events
http://www.cpearson.com/excel/events.htm

Private Sub Workbook_Open()
Msgbox "Hi"
End Sub

 

[merlin]

Can anyone tell me how I can make a message box appear
when the user opens the workbook?

Thanks!!

Sub Auto_Open()
MsgBox "Hello"
End Sub