excel alert box - excel 2003

[puzzlemaniac]

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

[Bushwhacker]

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

[puzzlemaniac]

BW,

Thanks very much, exactly what I wanted.

Cheers