Hi Gord,

I'm using Excel 2003.

Perhaps I did not explain my case clearly. I'm now creating an Excel for
data input from other parties, so I need to create sort of user form. One of
the input field is a VB combo box consists of 4 options. I selected "allow
users to edit range" (also include cells of "Cell Link" from VB) and protect
the worksheet.

This user form works fine except the VB object. The user cannot change the
content of combo box once the worksheet is protected.

My question is: how can we let users to alter combo box selection while
protecting the worksheet at the same time. Note: my form always uses VB check
boxes and they are "frozen" when worksheet is protected.

Hope I explain my situation clearly to you, thanks.
Jeff.



"Gord Dibben" wrote:

Jeff

What version of Excel?

2002 and newer allow "edit objects" in the list when protecting the worksheet.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 11:43:01 -0700, Jeff wrote:

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.