I could possible use workbook protection, if I can modify this piece o
code to work:

'set validation for Advisor
With ActiveSheet.Cells(myRow, Advisor).Validation
.Delete
.Add Type:=xlValidateList, Formula1:="=Advisor"
End With


That code works when protection isn't off, but doesn't when it is on.

Any help on this would be gratefully received.

Cheers

--
Message posted from http://www.ExcelForum.com