Lock Checkboxes?

[wagonwes]

Hey all,

I am wondering if there is a way to keep someone from changing the state of a checkbox (from the forms toolbar, not the control toolbox).

Right now I have the lock and lock text boxes checked for all of the checkboxes - by going to format, protection. I know that this should only make a difference when the worksheet is protected, but it does not seem to do anything. I can't edit the text or resize the box, but I can still check/uncheck it.

Is there any way to keep it from being checked/unchecked when the worksheet is locked? Or is there a macro I could maybe run to do this?

I have tried searching for a while, and I have came across nothing.

Thanks,

Wes

[shg]

Lock the linked cell.

[wagonwes]

Lock the linked cell.

Thanks! Worked great!

[Surii]

How do you lock the linked cell? Go to "format control", "Protection" tab, and check "Locked"? This is already done by default, I still can check/uncheck the checkbox even though it has no effect and it does or links nothing.

But I want it to prevent checking/unchecking too.

I tried to code this way but it is not working:

With ActiveChart.Shapes("Check Box 2").ControlFormat
.Value = xlMixed
.LinkedCell = Locked
End With