Hi All,

I have built a spreadsheet which uses VBA to present the user with a list of
choices by creating a dialog sheet "on the fly". The user checks the
checkbox to turn it on

The list can be up to approx 100 items in length. The problem that l am
having is that after 36 iterations the VBA code stops. Each iteration copies
an existing worksheet, places it in the workbook before a sheet named "end"
then renames it according the the name on the dialog sheet.

I am wondering if there are any limitations in Excel re the number of times
you can continually copy a worksheet, or there is a limit to the number of
worksheets in a workbook, or there is a limit to the number of checkboxes on
a dialog sheet or indeed anything else.

If exit from break mode where the code stops l am unable to manually copy
any sheet and Excel appears to be doing something but nothing happens, Excel
just returns to normal.

I have tried the code with Excel97 & Excel2000 under various OS and the
result is always the same

All suggestions greatly received

Regards

Michael Beckinsale