Re: Navigating within worksheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Simon,

How about a custom toolbar with a menu tree? Obviously not what you
were after in terms of the frozen panes, but this would 'follow you
around the work***' as it were if you din't have it docked?

Cheers,
JF.

"=?Utf-8?B?U2ltb24=?=" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:<48C4726F-5BAD-4725-983D-227E4FC27538@xxxxxxxxxxxxx>...
> I have a spread*** around 6000 rows long. I want to include a means of
> navigating around the spread*** in a freeze framed section at the top. I
> have considered a number of options including a simple drop down list (via
> the validaton command) and a goto button in VBA or the use of a dropdown list
> and hyperlinks.
>
> While this works reasonably well there are arond 100 locations I wish to
> navigate to and including these in a single drop-down list is not practical -
> I really want to be able to have some sort of drop down list which displays
> 10 high level categories, then within each of these categories a further 10
> sub categories, much like standard office menus. Does anyone have any useful
> pointers or VBA to help me achieve this
>
> cheers
>
> Simon
.

Quantcast