Predetermine Worksheet to Start In
 

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

Predetermine Worksheet to Start In
 

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 ;-)

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"mickeyblake" wrote in message
...
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

Predetermine Worksheet to Start In
 

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" wrote in message
...
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

Predetermine Worksheet to Start In
 

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

Predetermine Worksheet to Start In
 

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

"mickeyblake" wrote in message
...
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