Locking Excel Sheet with Control Toolbox controls

  • Thread starter Thread starter Christmas May
  • Start date Start date
C

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
 
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.
 
Back
Top