ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unprotecting Cells in a Protected Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/2350-unprotecting-cells-protected-worksheet.html)

Mark F

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?

Frank Kabel

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?




Mark F

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