validation lists and protected work sheets
 

with the sheet unprotected, select the cells and do
Format=Cells=Protect tab and uncheck Locked.

Data validation should then work when the sheet is protected.

--
Regards,
Tom Ogilvy


"Michael H" wrote in message
...
Hi all
I was thinking about previous posting and perhaps it as a
little to specific/confusing.

Real question is, can someone show me how to use a data
validation list on a protected Excel 2002 Worksheet.

Have been using activesheet.unprotect /protect in the work
sheet change procedure in Excel 2000.

Help much appreciated

Michael