+ Reply to Thread
Results 1 to 2 of 2

IS there a way to create multiple tabs WITHIN a spreadsheet?

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    California
    MS-Off Ver
    Excel 2011
    Posts
    13

    Question IS there a way to create multiple tabs WITHIN a spreadsheet?

    Hi, using Excel 2010 here.
    I was wondering if there is a wy to create multiple tabs within a spread sheet??? Using HTML??? Or something similar ??

    THanks!

  2. #2
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: IS there a way to create multiple tabs WITHIN a spreadsheet?

    You could simulate the effect using macros. The attached workbook uses named ranges. "Tabs" is the range of cells used to simulate tabs. Then you name your ranges to correlate to the values in each of the "Tabs" cells. Then you use the following code in the sheet's module to hide and unhide the appropriate ranges.

    Please Login or Register  to view this content.
    Please see the attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1