use the following sub in one of your modules

Sub Auto_Open()

'Action to be done when the excel sheet starts
'enter your code here

end su

--
Message posted from http://www.ExcelForum.com