Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change format protection default to unlocked?
Apparently, by default, all cells in a worksheet are locked (Format Cells
Protection). Consequently, when I set worksheet protection (Tools Protection Protect Sheet Password), all cells are protected. I want to protect just 4 cells. So I think I want the default for all cells to be unlocked. Then I would lock the 4 cells and set worksheet protection. Of course, I could manually select every cell in the worksheet (A1:IV65536) and change the Protection format to unlock. But besides being a "pain", it appears to increase the worksheet size "unnecessarily". Is there a better way to change the default cell protection to unlocked? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is AutoSum iinoperable w/protection when column is unlocked? | Excel Worksheet Functions | |||
How do I change default number format? | Excel Discussion (Misc queries) | |||
How to change default to keep spreadsheet unlocked? | Excel Discussion (Misc queries) | |||
How to change default format | Charts and Charting in Excel | |||
How do I change the default format for a comment? | Excel Discussion (Misc queries) |