ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple tabs in 1 worksheet (https://www.excelbanter.com/excel-programming/440003-multiple-tabs-1-worksheet.html)

misskh

Multiple tabs in 1 worksheet
 
Hi,

Pls help..I have about 10 tabs in the current workbook. I saw an excel
template that allows the user to have multiple tabs in the 1
worksheet. Does anyone know how this is done?

Thanks.

joel[_728_]

Multiple tabs in 1 worksheet
 

I finally figured outc how to do this.

1) Go to toolbar menu (View toolbars) and select Command toolbox.

2) Select the addional Controls (hammer and wrench)

3) Choose Microsoft Office Spreadhseet.

4) Place multiplle spreadsheets onto one of you spreadsheets in your
workbook.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182858

Microsoft Office Help


Dave Peterson

Multiple tabs in 1 worksheet
 
I wouldn't do this.

It so non-standard that I would think that you'd confuse your users more than
anything.



misskh wrote:

Hi,

Pls help..I have about 10 tabs in the current workbook. I saw an excel
template that allows the user to have multiple tabs in the 1
worksheet. Does anyone know how this is done?

Thanks.


--

Dave Peterson

Peter T

Multiple tabs in 1 worksheet
 
That's the Web Component which you can also put on a form. It's not the same
as an Excel spreadsheet, generally much more limited. However it has 262144
x 18728 cells (rows x cols) in xl2003-

Regards,
Peter T

"joel" wrote in message
...

I finally figured outc how to do this.

1) Go to toolbar menu (View toolbars) and select Command toolbox.

2) Select the addional Controls (hammer and wrench)

3) Choose Microsoft Office Spreadhseet.

4) Place multiplle spreadsheets onto one of you spreadsheets in your
workbook.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=182858

Microsoft Office Help





All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com