Frozen worksheet section to show on all other worksheets

[Steve]

I have created a "Navigation" tab that has buttons using macros that take you
to all the other tabs in my workbook. I used VBA code to hide all my tabs
except for the Navigation one. This way I can click on button that take you
to the tab but its all seamless to the viewer and makes it more like a
dashboard.

The problem is that I have to keep going back to the dashboard to choose
another tab or add all the buttons to every tab.

Is there a way to permanently split the windows or show that appropriate
area of the navigation page at the top of every tab so i have all those
buttons at the top and can just click on the button to go to the tab?

Appreciate any help you can offer?

 

[Gord Dibben]

Steve

How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g>

See this google search result. All one line for the URL

http://groups.google.com/group/micr...464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25



Gord Dibben MS Excel MVP