| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking specific cells in a workbook
"Sarah" wrote:
Somehow the way I know how to lock specific cells in a workbook isn't working. can you remind me how to do it please? The process would be: 1. Unlock all cells in the sheet first Select the entire sheet, Click Format Cells Protection tab Uncheck "Locked" OK (As Dave pointed out, all cells are "locked" by default) 2. Lock those specific cells/ranges Hold down CTRL key and multiselect all the specific cells/ranges Click Format Cells Protection tab Check "Locked" OK 3. Apply sheet protection Click Tools Protection Protect Sheet Password? OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i protect specific cells in a shared workbook? | Excel Worksheet Functions | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Macro to copy specific cells from one workbook to another | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| shared workbook keeps locking and "unsharing" - why? | Excel Discussion (Misc queries) | |||
Threaded Mode
