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?

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/micro...c19464f875bd25



Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 09:32:01 -0800, Steve
wrote:

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?