| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| checkboxes and cell-link references...is there a better way | Excel Worksheet Functions | |||
| checkboxes and cell-link references | Excel Discussion (Misc queries) | |||
| Maintaining a formula in a cell when there was an insert row | Excel Discussion (Misc queries) | |||
| Copy a formula maintaining a constant cell | Excel Worksheet Functions | |||
Threaded Mode
