How to lock a checkbox?

[bhenderson]

Hello,

I am trying to lock a checkbox that is assigned to a macro so that it cannot be changed once the macro has initiated. If a user tries to uncheck the box the macro tries to re-run. I feel like protecting the drawing objects in the sheet would be the easiest way to solve this but if someone has a better idea feel free. I cannot directly define the checkbox name in my code because the checkboxes themselves are changing and being created due to previous macros in the form. I would need a variable and I don't know how to do that.

Right now I am using:

Please Login or Register  to view this content.

Although the code does protect the sheet the checkbox can still be modified... I am guessing that I need to lock something else but I am not sure what. I cannot lock the whole worksheet because some fields need to be filled in by the user.

Any ideas?
Thank you,
Ben

[111StepsAhead]

Post an example workbook with example data if you can.

[bhenderson]

The sample below has the checkbox and code I am referring to. I am hoping to either make the checkbox inactive after being clicked or to create an "undo" button to put it back to its original state. I have tried both and have had problems with each. I figured it would be easier just to lock the checkbox.

Thank you for your help.
Ben