Locking Excel Sheet with Control Toolbox controls
 

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

Locking Excel Sheet with Control Toolbox controls
 

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.

"Christmas May" wrote:

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