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!
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!
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 see the attached.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks