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
"Arup C" wrote:
Hi Mike
I am still not able to do that.
This is giving error msg. saying Runtime error 9, subscript out of range
"Mike H" wrote:
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
"Arup C" wrote:
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.