can you copy the code statements under
Private Sub Workbook_Open()

goto vbeditor-control+r if the vbplroject window is not open
right click <thisworkbok under the particular flle-clck view code
your see
Private Sub Workbook_Open()
under this copy the code.

try this

--
venkat1926Posted from - http://www.officehelp.i