Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 119
Default Rules for locking controls

I can't quite figure out what is happening and why. I'm makng a sheet with a
bunch of Form Controls Checkboxes. In the cells next to the boxes I'm added
text be associated with the checkbox. I'm not using the text field available
in the control because I want to be able to cut and paste and use other
normal Excel cell behavior of cells next to the checkboxes.

Somehow, I've gotten some text cells linked to the checkbox control. When I
cut and paste the text cells, the checkboxes are cut and pasted with them.
But there are other cells that LOOK the same with checkbox next to text, but
these checkboxes DON'T get cut and pasted with the text cells.

Is there something going on about ajacent cells or something?

What's causing the cells to be linked
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
Some rules about Vlookup JohnC[_2_] Excel Discussion (Misc queries) 2 January 26th 10 01:50 AM
how do I set up a validation rules with two data rules Trudy Excel Worksheet Functions 1 October 16th 06 05:42 AM
Locking Controls Rob J Excel Discussion (Misc queries) 0 September 26th 06 02:57 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM


All times are GMT +1. The time now is 11:36 AM.

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

About Us

"It's about Microsoft Excel"