Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allowing editing locked cells in a protected sheet in excel
Hi,
1. I have an protected excel sheet in which Columns A,B,C are locked and cannot be editted by everyone however columns D and E are open to be edited by everyone. 2. However my problem is when I click on protect worksheet and add myself in the permissions tab to edit without password, I cannot edit and the whole sheet gets locked. This is not expected. Please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allowing editing locked cells in a protected sheet in excel
If columns D & E are formatted to not be locked, you should always be able to
edit them. Are you making sure to enter the same password for both the ranges you can edit, as well as the password to protect workbook? When you add yourself, make sure your checking the name, so computer verifies it recognizes what you inputted. Other than that, I'm not sure, as I am unable to duplicate your problem. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "phoenix" wrote: Hi, 1. I have an protected excel sheet in which Columns A,B,C are locked and cannot be editted by everyone however columns D and E are open to be edited by everyone. 2. However my problem is when I click on protect worksheet and add myself in the permissions tab to edit without password, I cannot edit and the whole sheet gets locked. This is not expected. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing comments in unlocked cells within protected sheet | Excel Discussion (Misc queries) | |||
ALLOWING ONLY DATA INSERTION IN LOCKED CELLS | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Allowing hyperlinks an a protected sheet | Excel Discussion (Misc queries) | |||
Still can select locked cells in protected sheet | New Users to Excel |