sparafucile1
11-12-2007, 10:39 AM
I want a checkbox click() sub to write a value to a cell. I got this part down pat an works just fine. But I want to write protect the sheet so the user doesn't fat-finger something and break the formula's that I so-carefully put together.
So, naturally I protected the sheet with a specific password. But now my checkbox click() events are locked out. Can I "enter" the password for my VBA commands somehow to allow them to work as normal?
I realize that a determined individual could snarf out the password and still be malicious. That's not what I'm trying to prevent. It's the user who accidentally overwrites a formula or some other value.
I want the checkboxes to control everything!!:yes
Thanks,
Jeff
So, naturally I protected the sheet with a specific password. But now my checkbox click() events are locked out. Can I "enter" the password for my VBA commands somehow to allow them to work as normal?
I realize that a determined individual could snarf out the password and still be malicious. That's not what I'm trying to prevent. It's the user who accidentally overwrites a formula or some other value.
I want the checkboxes to control everything!!:yes
Thanks,
Jeff