Layering worksheets

  • Thread starter Thread starter J Donahue
  • Start date Start date
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
 
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
 
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
 
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...
 
Back
Top