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.....

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.....