Apply Validation on a protected sheet

F

Frederick Chow

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
 
Top