Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls on Excel Sheets from Control Toolbox | Excel Programming | |||
Calling same event for all the toolbox controls in the sheet | Excel Programming | |||
Control Toolbox Controls | Excel Programming | |||
Control Toolbox Controls keep resizing ?? | Excel Programming | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming |