Always open a worksheet at A1
 

I have created a file with several worksheets - there will be about 20 tabs
in all and hyperlinks to navigate between them. When I move from worksheet to
worksheet, using tabs or hyperlinks, it doesn't always open at A1...how can
I ensure that a worksheet will always open at A1?

Be careful what you ask for you may just get it.
It will play havoc with hyperlinks to cells as well as not put you
where you left that sheet.

Code goes into this workbook
right click on the excel logo to the left of the menu bar
view code
insert the following code after Option Explicit

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveSheet.Cells(1, 1).Activate
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nimbus55" wrote in message ...
I have created a file with several worksheets - there will be about 20 tabs
in all and hyperlinks to navigate between them. When I move from worksheet to
worksheet, using tabs or hyperlinks, it doesn't always open at A1...how can
I ensure that a worksheet will always open at A1?

Thanks David..looks like it worked.
Sharon

"David McRitchie" wrote:

Be careful what you ask for you may just get it.
It will play havoc with hyperlinks to cells as well as not put you
where you left that sheet.

Code goes into this workbook
right click on the excel logo to the left of the menu bar
view code
insert the following code after Option Explicit

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveSheet.Cells(1, 1).Activate
End Sub
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nimbus55" wrote in message ...
I have created a file with several worksheets - there will be about 20 tabs
in all and hyperlinks to navigate between them. When I move from worksheet to
worksheet, using tabs or hyperlinks, it doesn't always open at A1...how can
I ensure that a worksheet will always open at A1?