Navigation Bar

I had an idea for a navigation bar, and I'm not sure if it is even possible.

I want one to function as a "directory tree"

So, it would look something like this:


[Home] | [Payment] [Agreements] [Project Information]


Home would be stationary, and pretend that each of those is a button on a user form.

If I clicked on "Agreements" I would want it to hide the payment and project information buttons, and load on top of where they are these buttons, leaving home where it is, and moving agreements to the left, so it would now look like this:

[Home] | [Agreements] | [IPA] [ITA] [AAL] [4Page]

then clicking home would go back to the first button set up.


This would be an awesome solution to minimize the size of the navigation bar, and maximize the working space.

Thanks in advance!

If it's possible, I know someone here can do it.

Robert

oh, i'm sorry, yes, a navigation form.

i thought about the multi-page, but that's not as "clean" as I wanted it to be.

ok, so, i can somehow click a button and it will change the captions and the results from the captions?

in my example, let's say "home" just resets the captions to the first example.

"Agreements" goes to a sheet named Agreements, and the 4 Options that pop up when the happens are locations on that worksheet.

When you click a button can you make other buttons on the user form "show" so that you have print options?

i want it to be very thin and out of the way, adding the multipage adds a bit of extra on the top, and I'd just prefer it to change the buttons instead of flip the pages...

unless, can you hide the "tabs" on the pages and keep it thin?

that would work.