Pop Up Message Box when opening an Excel File

Rickd · Apr 16th, 2002, 12:00 AM

I did this before. I know Excel has the capability of alerting users with some instructions when they open an Excel file. I forgot how I did it. I did it before.. I can anybody help?!! I just want a messagebox to alert them, when they launch a workbook.

Thanks in advance!!!!!!

Ricky Morris · Apr 16th, 2002, 12:07 AM

Try this:

Sub Auto_Open
Msgbox "Enter your message here"
End Sub

Apr 16th, 2002, 12:07 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try this: Sub Auto_Open Msgbox "Enter your message here" End Sub __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 12:00 AM	#1
Rickd New Member Join Date: Apr 2002 Posts: 1	I did this before. I know Excel has the capability of alerting users with some instructions when they open an Excel file. I forgot how I did it. I did it before.. I can anybody help?!! I just want a messagebox to alert them, when they launch a workbook. Thanks in advance!!!!!!