D Dave Peterson Nov 2, 2006 #2 How about recording a macro when you did it manually. Then name that macro Sub Auto_Open()