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 worksheet' as it were if you din't have it docked?

Cheers,
JF.

"?B?U2ltb24=?=" wrote in message ...
I have a spreadsheet around 6000 rows long. I want to include a means of
navigating around the spreadsheet 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