Always open a worksheet at A1

N

Nimbus55

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?
 
D

David McRitchie

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
 
N

Nimbus55

Thanks David..looks like it worked.
Sharon

David McRitchie said:
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 said:
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?
Click to expand...
Click to expand...
 
Top