I overprotected my spreadsheet! Need help ASAP!!
So I try to unprotect my worksheet so that anyone in my network can do
whatever they want to it. Now all I see is "The cell or chart you are trying to change is protected and therefore read-only" "To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (tools menu, Proctection submenu.) You may be prompted for a password" A little vague and... it didn't work... step by step help please!! |
I overprotected my spreadsheet! Need help ASAP!!
Step by step
click Tools|Protection|Unprotect sheet then (if prompted) enter the password you used. Mike "HoganD87" wrote: So I try to unprotect my worksheet so that anyone in my network can do whatever they want to it. Now all I see is "The cell or chart you are trying to change is protected and therefore read-only" "To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (tools menu, Proctection submenu.) You may be prompted for a password" A little vague and... it didn't work... step by step help please!! |
I overprotected my spreadsheet! Need help ASAP!!
What is vague about the suggestion?
Your sheet is obviously protected via ToolsProtectionProtect Sheet. To unprotect it go to ToolsProtectionUnprotect sheet. Provide a password if one is required. If you don't know the password you can copy all the date to a new sheet. Gord Dibben MS Excel MVP On Mon, 10 Sep 2007 09:50:04 -0700, HoganD87 wrote: So I try to unprotect my worksheet so that anyone in my network can do whatever they want to it. Now all I see is "The cell or chart you are trying to change is protected and therefore read-only" "To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (tools menu, Proctection submenu.) You may be prompted for a password" A little vague and... it didn't work... step by step help please!! |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com