Moving in multi-sheet document

  • Thread starter Thread starter sah2809
  • Start date Start date
S

sah2809

A couple of simple questions that I can't find an answer to. Any hel
gratefully received! I'm using Excel 2000.

I have a document containing about 40 pages. To simplify navigation
I've set up an index page. When I open the file, I'd like it to open a
sheet1 (index) automatically - is this possible?

I'm using simple macro buttons to move. I can get to the sheet OK, bu
I've added code to move the cursor to cell A1 - Range ("A1").select
but this generates an error code. There must be a better way to d
this - any ideas?

Regards,

Stuart Hasting
 
Put this code in your workbook module.

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

HTH.
 
Thanks - I can now get the workbook to open at the index sheet. However, I
still get an error when moving between sheets when I try to get the cursor
placed into cell A1.

The script I'm using is simply:

Sheets("Servers - Suppliers").Select
Range("A1").Select

Can anyone suggest a method that works, please?
 
Ignore previous post. I've found a method of gettnig this to work. It may
not be the best, but it's effective!

Application.Goto Reference:=Worksheets("Servers - Firmware").Range("A1"), _
Scroll:=True
 
Back
Top