Try this macro:

Sub Auto_open()
Sheets(1).select
cells(1,1).select 'If you want it to go to the A1 cell
End Sub

Cheers,
AP

"confused" wrote in message
...
Hi

is it possible to always force a particular worksheet to be the visible
active one every time the spreadsheet is opened?

So for example if I have sheet1 and sheet2, and save the spreadsheet while
in sheet2, the next time I open the spreadhseet, I want to force sheet1 to
be
the visible sheet.

is there some sort of 'on-open' function I could use with a macro that
directs to sheet1?

thanks for any help