How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?

**MarvinP** · 04-01-2011, 02:46 PM

Hey e,

Nimrod is absolutely correct

. Excel has most everything we need already and we as humans simply need to find how it does our work for us.

A few years back I needed to filter a pivot table for a user programatically as he felt the Excel way was too complicated. I created this user interface instead of teaching him how to use the normal pivot table dropdown filters. It took days to figure out the code and the lists and the code

. Now that he's learned how to use the standard method, he has a better understanding of how it works and more capabilities that I every wrote code for.

YOU NEED to use the standard method of simply clicking on the tabs at the bottom of the workbook to change tabs. Left and Right become obvious

when you can see which tab you are on. Why do you want to create another method/standard for doing something easy in excel when it is already there and easy to learn or teach.

**e4excel** · 04-01-2011, 03:09 PM

There are lot of Print-Outs to be taken from this SHeet and therefore wanted to make it easier for the person to move between SHeets.

Actually, I didnt know about the default Index you and The KeyBoard ShortCuts mentioned..so grateful to you for the same,..

Dear MarvinP and NimROd,

With Due Respect to both your views on Tab Movement, I would like to mention that I would have difinitely prefered the simple option but the reason for the requirement was to make it faster as the Pointer needs to be at a particular cell and which can be achieved with a HyperlInk but since HyperLinking several sheets was time-consuming thought of a better way to achieve that..

Regards
e

**nimrod** · 04-01-2011, 04:01 PM

Hello e4excel;
Please don't think I'm trying to "dis" you . I respect that you are learning and trying new things. I think that most people that get good at this stuff do exactly that. But with this project I think , in the long run , it's alot of effort for not much return. With that said have you looked at the built-in "custom views" ? Excel allows you to drag a "Custom Views" drop down menu onto you menu bar. You then select the cells , sheets and views (i.e. rows hidden etc) and then give that view a name in the drop down menu. Then the user just selects that view from the menu. In short your "index" would always be available on the tool bar.

Good luck with you experimentation.

**e4excel** · 04-04-2011, 07:53 AM

Dear NimRod and MarvinP,

I respect your views and completely agree with you that this is too simple a request to move between the tabs but the reason of asking for its is to Save the Time by taking the pointer to always a particular cell from where there the person can take control of the Sheet for Printing the Sheets contents which are already formatted for the Print Preview..

Hope you understand..!

I have tried to make up some code of my own with great help from the Forum and TMShucks inital code however theres something which is missing as I am getting an error mentioning that "REFERNCE IS NOT VALID"

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Range("e1").Value = "Go to " & ActiveSheet.Previous.Name
If Target.Address = "$E$1" Then
'Target.Value = Time
ActiveSheet.Hyperlinks.Add _
Anchor:=Range("E1"), _
Address:="", _
SubAddress:=ActiveSheet.Previous.Name, _
TextToDisplay:="Go to " & ActiveSheet.Previous.Name


End If
End Sub

Would appreciate if someone could just tweak a little..
I think instead of the "ActiveSheet.Hyperlinks.Add _" it needs to be the Previous SHeet...

Warm Regards
e4excel