View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CSK CSK is offline
external usenet poster
 
Posts: 8
Default Form Checkboxes are not maintaining cell link

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.