KC Cat
New Member
- Joined
- Dec 23, 2009
- Messages
- 48
I have a workbook with 2 sheets. Both sheets are password protected. I saved the workbook such that cell A1 of the left-most sheet is the active, or selected, cell. Meaning, when you open the workbook, that is where the cursor is.
When I click the tab for the 2nd sheet (right-most), the following error pops up with just an "Okay" button.
The cell or chart you are trying to change is protected and therefore read-only.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password.
Upon clicking "Okay", the same error pops up again, and again - 5 times total.
I do not understand why this is happening, as all I am doing is selecting the sheet. I'm not trying to change any cell contents at all.
I'm sure this has something to do with the "locked" status of cells on the sheet, and the fact that the sheet is password protected - I just can't figure it out what!
Any help will be much appreciated.
When I click the tab for the 2nd sheet (right-most), the following error pops up with just an "Okay" button.
The cell or chart you are trying to change is protected and therefore read-only.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password.
Upon clicking "Okay", the same error pops up again, and again - 5 times total.
I do not understand why this is happening, as all I am doing is selecting the sheet. I'm not trying to change any cell contents at all.
I'm sure this has something to do with the "locked" status of cells on the sheet, and the fact that the sheet is password protected - I just can't figure it out what!
Any help will be much appreciated.