If doing it from code, unprotect the sheet, change the object, then protect
the sheet.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jeff" wrote in message
...
I created some VBA objects like drop-down-list, checkbox. However, when I
protect the worksheet, I cannot change the VBA objects to another value.
Error message appears saying "The cell or chart you are trying to change
is
protected and therefore read-only".

Can I all users to edit the VBA ojects while the worksheet is protected?
Thank you very much.