Default open sheet

  • Thread starter Thread starter BIG-DB
  • Start date Start date
B

BIG-DB

Hi Folks.

I would like an excel file to open on sheet 3 every time
the file is opened.

I have some users open the file and add data to sheet 1 or
2 and then save the file. Seems when we open the file next
it opens at the sheet last saved.? ie" 1 or 2

Is there a simple way I can have the file open on sheet 3
every time. I want the users to see daily calculation on
sheet 3 before they add any new data via a userfom that is
activated by a button on sheet 3.

I would appreciate any help/suggestions on this.
David
 
Is there a simple way I can have the file open on sheet 3
every time.
Click to expand...

Use code in the workbook module, e.g.

Private Sub WorkBook_Open()
Sheets("Sheet3").Select
End Sub

Rightclick the XL icon next to File in the menu bar, select View Code. Paste
the code in there. Close the Visual Basic Editor, then save the file.

Rgds,
Andy
 
Hi Andy

thanks very very much for that.
-----Original Message-----

Use code in the workbook module, e.g.

Private Sub WorkBook_Open()
Sheets("Sheet3").Select
End Sub

Rightclick the XL icon next to File in the menu bar, select View Code. Paste
the code in there. Close the Visual Basic Editor, then save the file.

Rgds,
Andy


.
Click to expand...
 
Back
Top