Donate SIGN UP

excel alert box - excel 2003

Avatar Image
puzzlemaniac | 10:02 Tue 01st Apr 2008 | Computers
2 Answers
How can I add an alert box which appears when an excel file is opened? The box would contain a short message advising of a current status (which I would want to be able to change from time ot time), with an OK button to then close the alert box but leave the file open?

I am using excel 2003, and believe it was possible on earlier versions of excel but cannot see it in 2003
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by puzzlemaniac. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Right click on the Excel icon (next to the File dropdown menu) > Select View Code

Copy and Paste these 3 lines into the module :

Private Sub Workbook_Open()

MsgBox "Put Your Message Text Here Within The Quotes"

End Sub

From the File menu > Select Close and Return to Excel.

Save and Close the File. Now Open the file again and your message box appears.

BW

Question Author
BW,

Thanks very much, exactly what I wanted.

Cheers

1 to 2 of 2rss feed

Do you know the answer?

excel alert box - excel 2003

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.