Open spreadsheet on 'home' page

  • Thread starter Thread starter Beanymonster
  • Start date Start date
B

Beanymonster

Hi all,
I am currently using Excel 2002 and have a workbook with multipl
worksheets. Is it possible to force the workbook to open on the sam
page every time (ie the front page)? Currently, the workbook opens o
whatever page was last viewed when it was closed and saved.
thanks in advance

Bret
 
Put this in the ThisWorkbook module

Private Sub Workbook_Open()
Sheets("yournamedsheet").Select
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Index Page 1
Linking separate spreadsheets 7
Using a macro to open spreadsheets 2
Spreadsheet Stuck 1
Excel 2007 page break changes when forwarding workbooks 1
How to copy a whole Excel spreadsheet page in 2007 vs 2003? 2
Open at same sheet everytime 2
Drop down to open a different spreadsheet? 1

Back
Top