Allow users to edit ranges for VBA objects

[Guest]

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.

 

[Bob Phillips]

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)

 

[Gord Dibben]

Jeff

What version of Excel?

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


Gord Dibben MS Excel MVP

 

[Guest]

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.

 

[Guest]

Hi Bob, I'm not writing in code. Just drag the object from VB toolbar and
change the data fields.

 

[Guest]

Hi Gord,
I can send you my file if you want to take a closer look, thanks.
Jeff.

 

[Guest]

Problem solved!

The "cell link" in VB objects will return value to certain cells. I right
clicked those cells, selected "format cells", under "Protection" tab,
UNCHECKED the "Locked" checkbox.

Then I can protect the worksheet, and change the VB objects!