I am assuming that Sheet6 is the name of sheet 6, change the name if it
is different than that.

you have to copy this code in "this workbook" at vba editor, save it
and close it.Now whenever the file is opened, it prints sheet6.



Private Sub Workbook_Open()
Sheets("Sheet6").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
end sub


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382078