I am trying to update cell data validation lists on a protected sheet. Using
protect/unprotect every time is cumbersome and difficult. So I am using
userinterfaceonly:=true so that the code can update protected sheets. But
this doesn't seem to allow it to update cell validation lists - I get the
familiar application-defined or object-defined error messsage. Suggestions
welcome. Thanks.