View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default 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.....