sheets in sheets

  • Thread starter Thread starter cornel
  • Start date Start date
Hi cornel!

The maximum number of sheets in a workbook is limited by available
memory.

By default the number of sheets in a new workbook is 3 but this may be
altered by using:

Tools > Options > General
Change to a maximum of 255

However, there is nothing to stop you adding more sheets.

Generally, you'll find things get very slow as you increase the number
of sheets and you might be better advised using more workbooks.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks, but you don't understand me. I want an ierarchical
structure of sheets.
Example:
In Sheet1 i need to have 3 sheets(1a,1b,1c). When i see
Sheet1 i want to be able to select Sheet 1a,1b or 1c. And
so on.
 
Hi cornel!

I don't think this is possible but see what others say.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
You could use the Activate/Deactivate events of the worksheets
Set the visibility of your sub-worksheets within those events

E.g. for "Sheet1

sub worksheet_activate (
Sheets ("Sheet1a").Visible = tru
Sheets ("Sheet1b").Visible = tru
Sheets ("Sheet1c").Visible = tru
end su

sub worksheet_deactivate (
Sheets ("Sheet1a").Visible = fals
Sheets ("Sheet1b").Visible = fals
Sheets ("Sheet1c").Visible = fals
end su
 
I want to have many sheets in one sheet. It is possible?
Click to expand...

No. One possibility already mentioned would be hiding and unhiding worksheets
when the 'parent' worksheet is activated or deactivated, respectively. Another
possibility (but a poor one) would be embedding multisheet workbooks within a
worksheet.
 
Back
Top