can I make a specified sheet as startup sheet in a workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
Can I make a specified sheet as startup sheet in a workbook so that it open
the same sheet every time ? By default Excel opens the sheet which was open
at last save.
 
Hi,

You need a bit of code. Alt + F11 to open VB editor. Double click 'This
Workbook' and paste this in.

Private Sub Workbook_Open()
Sheets("Sheet3").Select ' Change to suit
End Sub

Mike
 
Hi Mike
I am still not able to do that.
This is giving error msg. saying Runtime error 9, subscript out of range
 
Hi,

Change this line to the name of the worksheet you want to be active on startup

Sheets("Sheet3").Select

i.e.
Sheets("Mysheet").Select

Mike
 
Thanx Mike solved my problem

Mike H said:
Hi,

Change this line to the name of the worksheet you want to be active on startup

Sheets("Sheet3").Select

i.e.
Sheets("Mysheet").Select

Mike
Click to expand...
 
Back
Top