Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply Validation on a protected sheet
Hi all,
How can I set the worksheet protection in such a way that users can apply his own validation on unlocked cells of a protected sheet? When a sheet is protected for contents, the Data | Validation command is dimmed even though an unlocked cell is selected. I am using Excel XP. Thanks a lot. Frederick Chow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Macro Errs when sheet is protected | Excel Worksheet Functions |