View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Form Checkboxes are not maintaining cell link

You sure that you're not just seeing the forms checkbox that was on that row
that got hidden.

Those form checkboxes won't resize when you hide the row.

If you're going to hide the rows, you may want to dump the forms toolbar
checkboxes and replace them with checkboxes from the control toolbox toolbar.

You can rightclick on those checkboxes (control toolbox toolbar types)
and choose format control|Properties tab|move and size with cells.

These'll be hidden when you hide the row.

Be careful. If you delete the row, you'll be left with an difficult to find
object.

And you assign the linked cell by rightclicking on the checkbox and choosing
properties.
Then type in the address in the Linkedcell property.
(different from the checkboxes from the Forms toolbar)

CSK wrote:

I have a bunch of Form Checkboxes on a worksheet. Each one is linked to the
cell that they are sitting on. For example, the checkbox in cell B40 is cell
linked to B40. The problem is, if I hide rows that have these checkboxes,
the remaining checkboxes sometimes have an incorrect cell link.
Example: Here are the rows and corresponding checkboxes.
B39
B40
B41
B42
B43
B44
I hide row 39 and 40. Now the checkbox in B41 has cell link to B39. I need
the checkboxes to stay with their corresponding rows.


--

Dave Peterson