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

Hi,

Private Sub Workbook_Open()
MsgBox "Your message"
End Sub

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



"Mirandah" wrote:

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

Thanks!

"Eduardo" wrote:

Hi,

Private Sub Workbook_Open()
MsgBox "Your message"
End Sub

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



"Mirandah" wrote:

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

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
--
HTH...

Jim Thomlinson


"Mirandah" wrote:

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