News1 min ago
excel alert box - excel 2003
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
I am using excel 2003, and believe it was possible on earlier versions of excel but cannot see it in 2003
Answers
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
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
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.