Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked Cell - can still edit
Good morning all,
i have a workbook whhere i want to lock most of the cells. Have selected all cells in the sheet, gone format protection select locked, then tools protection protect sheet. the majority of cells i cannot edit, but there are some where i can still edit. (FYI the cells i can edit were inserted previously) Driving me crazy Phil (Excel user of 7 years dazed by a simple protection problem ¦-( ) BTW Excel XP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked Cell - can still edit
press ctl+a.
you will see that sheet has been selected. got to the format,cell,protaction,uncheked the locked.press ok. now select the cell which u want to lock more than one press ctrl+right click and than once again repeat the above procedure. now u have to check the locked cell. protect the sheet. note: locked cell will work only on protect sheet "philcud" wrote: Good morning all, i have a workbook whhere i want to lock most of the cells. Have selected all cells in the sheet, gone format protection select locked, then tools protection protect sheet. the majority of cells i cannot edit, but there are some where i can still edit. (FYI the cells i can edit were inserted previously) Driving me crazy Phil (Excel user of 7 years dazed by a simple protection problem ¦-( ) BTW Excel XP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked Cell - can still edit
gone ctrl A, unlocked all cells, ok. again selected whole sheet, locked
cells, protected sheet. still some cells i can edit!! WHY??? hitesh wrote: press ctl+a. you will see that sheet has been selected. got to the format,cell,protaction,uncheked the locked.press ok. now select the cell which u want to lock more than one press ctrl+right click and than once again repeat the above procedure. now u have to check the locked cell. protect the sheet. note: locked cell will work only on protect sheet "philcud" wrote: Good morning all, i have a workbook whhere i want to lock most of the cells. Have selected all cells in the sheet, gone format protection select locked, then tools protection protect sheet. the majority of cells i cannot edit, but there are some where i can still edit. (FYI the cells i can edit were inserted previously) Driving me crazy Phil (Excel user of 7 years dazed by a simple protection problem ¦-( ) BTW Excel XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel |