I am trying to write VBA code that will look first to see if another workbook
is open, if open then go to sheet 1, if not open, then open it and go to
sheet 1.

You see I might need to go to this sheet several different times during the
day and I don't want to keep opening and closing the sheet.

Steve