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
"Stuart Hastings" wrote in message
...
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?
"Brad" wrote in message
...
Put this code in your workbook module.
Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
Range("A1").Activate
End Sub
HTH.
-----Original Message-----
A couple of simple questions that I can't find an answer
to. Any help
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 at
sheet1 (index) automatically - is this possible?
I'm using simple macro buttons to move. I can get to the
sheet OK, but
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 do
this - any ideas?
Regards,
Stuart Hastings
---
Message posted from http://www.ExcelForum.com/
.