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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Custom Buttons 3
custom pop up message 1
Printing Excel File Custom Properties in the Footer 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Excel How to Fix Damaged Excel File That Won't Open? 3
Create a pop-up message prior to opening sheet 5
Macro for pop up message box for auto-filter entry 2
Prompt user to input data (pop-up box) 2

Top