Predetermine Worksheet to Start In

[mickeyblake]

Hi everybody,
Very hot weather here in UK although having just put the washing out to dry,
the weather turns to rain!

Anyway, I have a workbook with several 'sheets', is it possible to force
Excel to start in a particular sheet that I have names Instructions?

I checked Google but got nowheere.

Thanks,
Mickey

 

[Harald Staff]

Hi Mickey

Sure. Paste in the ThisWorkbook module:

Private Sub Workbook_Open()
Sheets(1).Activate
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollRow = 1
Range("C3").Select
End Sub

Sorry to hear about the laundry ;-)

 

[Kerry]

Hi Mickey,

In your workbook, open the VB Editor and go to: 'This Workbook', put in this
code:

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub

Obviously change "Sheet1" to the sheet that you wish to activate on opening.

regards,
Kerry Bennett
www.excelaid.com

 

[mickeyblake]

Thanks Guys!
The rain has stopped and I am hoping the washing dries befor Judie wakes up
(poor lady was working nights)

I really appreciate the fast response and expert advice,
Thanks,
Mickey

 

[Harald Staff]

Hi Mickey

Glad it helped. Just email me the clothes, Oslo is like an oven today. I really should log
off and get outside.

Best wishes Harald
Excel MVP