Custom Messages in Excel

M

Mirandah

How would you create a custom popup message in Excel. I want to create a pop
up message as someone is opening my file.
 
E

Eduardo

Hi,

Private Sub Workbook_Open()
MsgBox "Your message"
End Sub
Click to expand...

change the message for yours, to enter the macro, right click on the mouse
over the tab name, view code, then at your upper left look for this workbook,
double click it and copy the above macro in the right side, close the VBA
application, then save the workbook as macro enable
 
M

Mirandah

Thanks!

Eduardo said:
Hi,

Private Sub Workbook_Open()

change the message for yours, to enter the macro, right click on the mouse
over the tab name, view code, then at your upper left look for this workbook,
double click it and copy the above macro in the right side, close the VBA
application, then save the workbook as macro enable
Click to expand...
 
J

Jim Thomlinson

This requires a macro... In the XL window right click the XL icon next to the
word File on the menu bar and select View Code. Paste the following in the
code window that opens up...

Private Sub Workbook_Open()
MsgBox "Tada..."
End Sub
 
Top