Thank you, I wasn't expecting an answer so quickly. will give it a go and get
back to you.

Many Many thanks
--
Smudge


"Bearacade" wrote:


Within the Visual Basic Editor (Alt-F11), click on the ThisWorkbook and
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 it


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570565