Security problem with controls in worksheet

[Michael Vautour]

I've built a worksheet that contains a few controls (check
box). I need to protect this worksheet, but maintain
access to these check boxes. I've set the security to
unlock on the cell in back of my control and also my
control is unlocked but I always get and error saying that
my worksheet is locked when I check or uncheck my control.
Can someone help me out on this one!

Thanks alot.

 

[Lydya]

I'm afraid all you can do with the Forms' check boxes is in the Format
Control.
I don't know of anyway to change the font size or color of the text.

For more features you will have to look into the ActiveX controls:
View / Toolbars / Control Toolbox
Click on the check box icon and draw it on your sheet, then click on the
Properties icon to choose your settings.
These controls can be used with or without vba.

More infos:
http://www.microsoft.com/officedev/articles/Opg/012/012.htm#dex1
ActiveX Controls and Dialog Boxes

http://www.erlandsendata.no/english/downloads/userforms.htm
UserForms and ActiveX-controls


Bye

Lydya


"Michael Vautour" <[email protected]> a écrit dans le message de
Thanks Lydya, this solves my problem. I have another one
for you guys is there a way I can format text of a control
that same check box text bigger or different color?

Thanks again!