Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to protect one cell "E3" on a worksheet, all other unprotected. I
have an area that is set up with the Data/AutoFilter where the dropdown arrows go across line 6, ie below the protected cell. Here is my issue: When I Set all the cells to Unprotected and then set E3 to Protected and then Protect the Sheet the AutoFilter is locked and not funtional. Is there another solution to this. Thank you, Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protect specific cell but allow edit on other cell | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Protect Cell Formatting | Excel Worksheet Functions | |||
protect cell | Excel Worksheet Functions |