How can I set a workbook to open always with a certain sheet I wan

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shariq - 20 Dec 2006 02:19 GMT

I'd like to have the workbook set to open alway with a certain page, no
matter where I was last time working on it, but it should open always with a
certain page I want

Reply to this Message

Nick Hodge - 20 Dec 2006 09:01 GMT

Shariq

Use a Workbook_Open() event in the workbook

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
Range("A1").Select
End Sub

To implement, right-click the small Excel icon for the workbook and select
view code. Paste here and save

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> I'd like to have the workbook set to open alway with a certain page, no
> matter where I was last time working on it, but it should open always with
> a
> certain page I want

Reply to this Message