Freeze section of worksheet to show on all other worksheets

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I posted this question in the Excel General forum but it may be more
appropriate here...

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?
 
Thanks Ryan for the reply. But this wouldn't work when I sent the file to
another Excel user would it? That's what I am trying to do.

Thanks,
Steve
 
Back
Top