I have a shared and protected sheet
Although the cells in question are unlocked VBA will not allow the
validation to be changed.

(Works fine if the sheet is unprotected but protection is necessary)


Is there a way round this

Thanks

--
Patrick