This project has moved. For the latest updates, please go here.

Data Validation Issue

Jun 23, 2011 at 10:09 AM

If I add a new sheet to a workbook and add in a Data Validation List my code works.

If however I open an existing sheet or copy a sheet the Data Validation causes the workbook to become corrupt and excel will open it correctly!

Is there a workaround for this as I need to copy a sheet which contains some VBA and conditional formatting

Also, is there way to rename a sheet other than copy and then delete the original?

Thanks

Coordinator
Jun 30, 2011 at 6:46 PM

Conditional formatting is not supported in the current version, so if you use that in your template you can get unexpected errors. I'll have a look at your issue (13721) later.

To rename a sheet just set the Worksheet.name property.