Copying an existing password protected sheet to a new workbook as an unprotected sheet gives the following error when user tries to type in data in the new worksheet.
Error: "the cell or chart you're trying to change is on a protected sheet"
This error happens only once. Click OK on the pop up error message and type again in a cell, then excel allows you to type data in the cells and save the sheet.
We have an excel (format .xls) file currently being used to create another excel spreadsheet when a button on a form in the same spreadsheet is clicked. It basically copies one password protected blank sheet (a template) to a new workbook as an unprotected sheet. The code below used to work with excel 2007(using .xls format). We recently upgraded from excel 2007 to excel 2013.
However the newly created sheet always shows the error message pop up shown in bold above whenever the user tries to enter in data in the new workbook. Any help or suggestions would be appreciated.![]()
Please Login or Register to view this content.
PS: please ignore the code where it says 'Delete this line
Bookmarks