Tags: cool, downloaded, dropdown, excel, feature, file, layering, menus, microsoft, msdn, software, tabs, web, worksheets

Layering worksheets

On Microsoft » Microsoft Excel

5,326 words with 5 Comments; publish: Thu, 22 May 2008 23:28:00 GMT; (30693.99, « »)

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

All Comments

Leave a comment...

  • 5 Comments
    • Have never seen that. Can you send the wb and I will have a look.

      --

      Don Guillett

      SalesAid Software

      donaldb.excel.todaysummary.com.281.com

      "J Donahue" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:077f01c3d540$5af6c1d0$a001280a.excel.todaysummary.com.phx.gbl...

      > 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

      #1; Thu, 22 May 2008 23:29:00 GMT
    • 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 .excel.todaysummary.com. cnerd.com

      "J Donahue" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:077f01c3d540$5af6c1d0$a001280a.excel.todaysummary.com.phx.gbl...

      > 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

      #2; Thu, 22 May 2008 23:30:00 GMT
    • Can I get a copy of that WB. TIA

      Greg

      "Don Guillett" <donaldb.excel.todaysummary.com.281.com> wrote in message

      news:uWqtFtU1DHA.3416.excel.todaysummary.com.tk2msftngp13.phx.gbl...

      > 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

      >

      > --

      > Don Guillett

      > SalesAid Software

      > donaldb.excel.todaysummary.com.281.com

      > "J Donahue" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:077f01c3d540$5af6c1d0$a001280a.excel.todaysummary.com.phx.gbl...

      > > 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

      >

      #3; Thu, 22 May 2008 23:31:00 GMT
    • Can you ask OP?

      --

      Don Guillett

      SalesAid Software

      donaldb.excel.todaysummary.com.281.com

      "Greg Rivet" <gregrivet.excel.todaysummary.com.hotmail.com> wrote in message

      news:%23UP52AW1DHA.1744.excel.todaysummary.com.TK2MSFTNGP12.phx.gbl...

      > Can I get a copy of that WB. TIA

      > Greg

      > "Don Guillett" <donaldb.excel.todaysummary.com.281.com> wrote in message

      > news:uWqtFtU1DHA.3416.excel.todaysummary.com.tk2msftngp13.phx.gbl...

      > > 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

      > >

      > >

      > > --

      > > Don Guillett

      > > SalesAid Software

      > > donaldb.excel.todaysummary.com.281.com

      > > "J Donahue" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > > news:077f01c3d540$5af6c1d0$a001280a.excel.todaysummary.com.phx.gbl...

      > > > 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

      > >

      > >

      >

      #4; Thu, 22 May 2008 23:32:00 GMT
    • 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

      Don Guillett

      SalesAid Software

      donaldb.excel.todaysummary.com.281.com

      "J Donahue" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:077f01c3d540$5af6c1d0$a001280a.excel.todaysummary.com.phx.gbl...

      > 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

      #5; Thu, 22 May 2008 23:33:00 GMT