Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Lock checkbox to cell?

Thanks Dave........really much appreciate.

Vaya con Dios,
Chuck, CABGx3


"Dave Peterson" wrote in message
...
There are two checkboxes and they have different settings.

If you use the checkbox from the Forms toolbar, you can rightclick on it
and
choose Format Control. Then on the Properties tab, you'll see two
available
options:

Move but don't size with cells
Don't move or size with cells

If you use the checkbox from the Control toolbox toolbar, you can
rightclick on
it and choose Format Control. On the Properties tab, you'll see the same
two
options and a third:

Move and size with cells.

So if you're going to change the size of the cells (even hiding the
rows/columns), you'll want to use the checkboxes from the control toolbox.






CLR wrote:

Hi All........
I don't use checkboxes myself, but I got asked today if there is a way to
lock them to a cell so they do not move or resize with the other cells.

TIA for any info,
Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson



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
I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. Leonid L Excel Discussion (Misc queries) 2 July 30th 08 04:25 PM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 2 January 21st 07 10:59 PM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 1 January 21st 07 09:44 AM
Lock Checkbox value Kingnothing Excel Programming 2 October 18th 05 08:23 PM
Checkbox Lock Leanne Excel Programming 3 January 11th 05 02:34 AM


All times are GMT +1. The time now is 11:57 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"