| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new workbook when 00 sheets are reached
Is it possible to have a code, so that when/if 100 sheets are reached in a
single workbook, then the first 3 sheets are duplicated and another worksbook is created ? I understand that having more than 100 or so sheets is not wise. I was hoping for up to 1000 sheet capability. Corey..... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create new workbook when 00 sheets are reached
Corey,
There is the Workbook_NewSheet event where you can test ThisWorkbook.Worksheets.count. If it exceed you limit, create a new workbook and copy over the first 3 sheet etc... (Not that I think it's a good idea, but..) As for 1000 WS in a WB, not sure, dependent on your version of XL. This may help: http://www.decisionmodels.com/memlimitsc.htm NickHK "Corey" wrote in message ... Is it possible to have a code, so that when/if 100 sheets are reached in a single workbook, then the first 3 sheets are duplicated and another worksbook is created ? I understand that having more than 100 or so sheets is not wise. I was hoping for up to 1000 sheet capability. Corey..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| create a pop-up alert when a condition is reached in excel | Excel Discussion (Misc queries) | |||
| create workbook, copy sheets | Excel Programming | |||
| Create New Workbook - Name book - 4 Sheets - Name Sheets | Excel Programming | |||
Hybrid Mode
