Default open sheet

[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

 

[Andy Brown]

Is there a simple way I can have the file open on sheet 3

every time.

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

 

[Guest]

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


.