View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
confused confused is offline
external usenet poster
 
Posts: 193
Default on open, always display sheet1

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