Excel Navigation

[penzer]

At the moment i have about 5 separate sheets. At this time they are all linked by simply clicking on macro buttons which then take you to the selected sheet. For my i.t project this wont cut it. I need more exciting/different ways of navigation other than macro buttons. Could any one give me some suggestions on what this could be and how to do it (in baby like steps).


P.S if someone is feeling especially generous and could spare some time on msn (max of 30 mins) just so i can send it over and get them to play around with it - please just post here and tell me if and when they are available- tonight or sometime.. THanks.

[VBA Noob]

Try hyperlinks

http://www.bettersolutions.com/excel...N011417330.htm

http://www.bettersolutions.com/excel...I911118770.htm

http://www.mvps.org/dmcritchie/excel....htm#hyperlink

VBA Noob

[penzer]

yeah i got a couple of hyper links already i forgot to mention that. but the thing is they are very much like buttons in the fact it involves one click and your away.

thanks for the links mate

any more suggestions please

[VBA Noob]

but the thing is they are very much like buttons in the fact it involves one click and your away

So what are you after then ??

VBA Noob

[penzer]

well drop down boxes maybe? such as having all the sheets listed and then selecting which one you want to go to,,, i just managed to do an add in called a navigation toolbar



can/do you have msn so i can show you and get help etc?

[VBA Noob]

Sorry I don't have MSN. Also posts should stay in the thread to help others

I assume it's this add-in
http://www.contextures.com/xlToolbar01.html

You could add buttons and link hyperlinks to those
You can navigate to a cell by naming it and typing the cell name in the Name box (Next to the formula bar)
List sheet names using hyperlinks as suggested and change the friendly name (See link)

VBA Noob

[penzer]

You can navigate to a cell by naming it and typing the cell name in the Name box (Next to the formula bar)

VBA Noob

could you elaborate on this, thanks for your help and yes it was that link.

[VBA Noob]

Link shows you how to name a cell and Name box
http://www.contextures.com/xlNames01.html

Once you name the cell type the name in the Name box and hit return and it will take you to that cell.

or if you want to select cells A1 to A500 type A1:A500 in the name box and hit return

Amended
Link for code examples
http://support.microsoft.com/kb/291308

VBA Noob