ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   problem with checkbox control (https://www.excelbanter.com/excel-worksheet-functions/80731-problem-checkbox-control.html)

Giselle

problem with checkbox control
 
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



Sean

problem with checkbox control
 
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






All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com