Unprotecting Cells in a Protected Worksheet
I have a multi worksheet workbook. Most of the workbook is protected, but I
have isolated cells that I want to unprotect becasue they represent variables for "what if" scenarios. How do I do it? |
Hi
before protecting the sheet select these cells and goto 'Format - Cells - Protection' and uncheck 'Locked' -- Regards Frank Kabel Frankfurt, Germany "Mark F" schrieb im Newsbeitrag ... I have a multi worksheet workbook. Most of the workbook is protected, but I have isolated cells that I want to unprotect becasue they represent variables for "what if" scenarios. How do I do it? |
IT WORKED! Thank you very much!
"Frank Kabel" wrote: Hi before protecting the sheet select these cells and goto 'Format - Cells - Protection' and uncheck 'Locked' -- Regards Frank Kabel Frankfurt, Germany "Mark F" schrieb im Newsbeitrag ... I have a multi worksheet workbook. Most of the workbook is protected, but I have isolated cells that I want to unprotect becasue they represent variables for "what if" scenarios. How do I do it? |
All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com