Tab code? When tab is selected, goto cell A1

[nhbartos]

Hi folks...
Got one for you...

Tabs.
I hate that all my tabs are scrolled to different locations within the data tables. They are on page 1, 2, 3, up, down, left...right...well you know.
I would like to know if I could code the tab to, when selected, go to a specific point or cell location...maybe a macro that runs when the file is opened or refreshed?

I have +/- 100 tabs and want each one to go to Cell D14 whenever it is selected or clicked on.
I would like every tab to automatically, when I click on it, to scroll to the top and place the cursor in cell D11.
A locked starting point maybe?


Get me?

 

[JoeMo]

This goes in a Thisworkbook module.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("D11").Select
End Sub

 

[My Aswer Is This]

You Quote:
I have +/- 100 tabs and want each one to go to Cell D14
I would like every tab to automatically, when I click on it, to scroll to the top and place the cursor in cell D11.
Do you want to go to D14 or D11

 

[nhbartos]

Sorry...typo...D14

 

[nhbartos]

ADVERTISEMENT

Not working...

 

[JoeMo]

Not working...

How/where did you install the code? Do you know what a Thisworkbook module is?

"Not working" is NOT very informative - what exactly happens when you activate a worksheet?

 

[nhbartos]

I got it going! Thanks JoeMo.

 

[JoeMo]

I got it going! Thanks JoeMo.

You are welcome - thanks for the reply.