Locking Excel Sheet with Control Toolbox controls

[Christmas May]

How do you "lock" a worksheet with controls from the Control Toolbox?

I would like the user to be able to select the control only. I don't want
them to be able to resize, rename, move, delete, etc the controls?

Thanks in advance,

Christmas May

 

[JLGWhiz]

The questions you are asking cannot be answered with any depth in this forum.
You might get some answers at this site. You can select a topic and Chip
gives a pretty good write up on how to use it.

http://www.cpearson.com/excel/topic.aspx

You can also open the Visual Basic editor, Alt + F11, and browse the help
files in the three Visual Basic References provided with each authorized copy
of Excel.