Hi all,

I want to protect an Object (e.g. Checkbox, Combobox) so that the User
cannot change the format of the object (move, etc..) and cannot access
the code of the object. But I want the User still use this Object (e.g.
Chech the check box or write in the Text box).

Can anybody help me?

Thank you in advance

Regards,
KingG


--
KingG
------------------------------------------------------------------------
KingG's Profile: http://www.excelforum.com/member.php...o&userid=34375
View this thread: http://www.excelforum.com/showthread...hreadid=548902

CommandButton1.Locked = True
ActiveSheet.Protect DrawingObjects:=True