Followup set to microsoft.public.excel.misc.

Just make sure the cell is unlocked prior to protection:
Format/Cells/Protection, uncheck the Locked checkbox). Validation
works fine on protected sheets.


In article ,
"ArDn" wrote:

I've tried that but the sheet is protected., so ...