Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all
I'm not sure I've got the write news group for this question, but here goes. I have a checkbox form control on my worksheet. I've set it's form control property to locked, and I've put protection on the worksheet. But when I right-click the edge of the control area, it is selected ??(it has the dotted box around it) How do I prevent this? I don't want the users to be able to move or alter the control. much thanks Giselle |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Consider using the checkbox on the Controls Toolbox toolbar instead of the one on the Forms toolbar. Hope this helps. Sean "Giselle" wrote in message ... Hi all I'm not sure I've got the write news group for this question, but here goes. I have a checkbox form control on my worksheet. I've set it's form control property to locked, and I've put protection on the worksheet. But when I right-click the edge of the control area, it is selected ??(it has the dotted box around it) How do I prevent this? I don't want the users to be able to move or alter the control. much thanks Giselle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Control toolbox Buttons disappear on click | Excel Discussion (Misc queries) | |||
calendar control - formatting | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
resize control checkbox with cell | Excel Discussion (Misc queries) |