Opening Excel to a particular worksheet

A

Aaron

Hello,
I have created a spreadsheet for a number of users to
access. I would like the spreadsheet to open on a
particular worksheet every time no matter where it is
saved.

The Worksheet that I would like to have as the default
page acts as a coversheet and has hyperlinks to other
input & savings worksheets.

Can someone please tell me how to open my spreadsheet up
at the 1 default worksheet every time.
Is it a macro or is it the way the shortcut is written?

If it is one of the above, how can I accomplish my goal?
 
N

Norman Harker

Hi Aaron!

Try:

In the VBA editor double click on 'ThisWorkbook' and insert the
following code:

Private Sub Workbook_Open()
worksheets("Sheet1").activate
Range("A1").select
End Sub

Change according to where you want to start at.
 
F

Frank Kabel

Hi
you have to use a macro (or to be precise an event procedure). Put the
following code in your workbook module (not in a standard module)

sub workbook_open()
me.worksheets("your_sheet").activate
end sub
 
Top