Pop Up Message

[Anna]

How do I make the pop up message in Excel, When I open the
XL spreadsheet?
For Example I'd like user see the pop up message "Any
further question please contact to IS" when they open the
Excel file.

 

[Alan]

Use Alt and F11 to open the VB Editor,
Double click 'This Workbook' on the left of the screen,
Enter this into the empty window on the right of the screen, (or copy and
paste),

Private Sub Workbook_Open ()
msgbox "Any further question please contact to IS"
End Sub

Save the file,
Regards

 

[Anna]

I type this code in the VB Editor then save the file, when
I open the workbook again, I don't see any pop up message.
Why? Thanks,

 

[Gord Dibben]

Anna

Code must go into the ThisWorkbook module since it is event code.

Take another approach......

Copy the below code from this message.

Private Sub Workbook_Open ()
msgbox "Any further question please contact to IS"
End Sub

With your workbook open, right-click on the Excel logo just left of the "File"
command.

Choose "View Code"

Paste the code in there.

Save the workbook, close and reopen.

Gord Dibben Excel MVP