Layering worksheets

J

J Donahue

I downloaded an excel file from a web site today and they
had a really cool feature on it.

The tabs for the worksheets were actually dropdown menus
and you could select different worksheets using this.

So basically they had only about 5 tabs showing but each
tab could be used to acces multiple worksheets.

Does anyone know how to do this?

Jeff
 
M

Michael Kintner

I have never seen this either can you send the file to me as well and I can
tell you how they did it. (smile)

Thank you,
Michael Kintner
CEO, Business Developer
CNerd Inc
mike @ cnerd.com
 
D

Don Guillett

I would like to get into the code as it was nicely done.
It appears that the sheet tabs were just hidden using
tools>options>view>sheet tabs
Then a custom toolbar was created with the menus and then attached to the
workbook
 
G

Greg Rivet

Can I get a copy of that WB. TIA

Greg
Don Guillett said:
I would like to get into the code as it was nicely done.
It appears that the sheet tabs were just hidden using
tools>options>view>sheet tabs
Then a custom toolbar was created with the menus and then attached to the
workbook
Click to expand...
 
Top