Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giselle
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert date using a pop up calendar control in a cell i Iain the scout Excel Discussion (Misc queries) 4 December 17th 05 08:10 PM
Control toolbox Buttons disappear on click Mangesh Yadav Excel Discussion (Misc queries) 2 September 16th 05 05:38 AM
calendar control - formatting arnoldarmy Excel Discussion (Misc queries) 1 April 25th 05 04:36 PM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
resize control checkbox with cell packat Excel Discussion (Misc queries) 2 December 27th 04 01:16 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"