Shirley,

Here is the code you need. Rob Van Gelder posted it in a reply to myself in the post below yours

Private Sub Workbook_Open(
'code you want to run when they open the spreadshee
End Su