Within the Visual Basic Editor (Alt-F11), click on the ThisWorkbook an
enter this into the main window:

Private Sub Workbook_Open()

MsgBox ("This Macro Run on Open")

End Sub

Close the Visual Basic Editor, Save the Worksheet, Close it and Open i

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=57056