A
Andy S
Hello,
I am working on a project where every row has a group box with option
buttons (form control) to drive certain macros. Each response generates a
summary of data (through cell links) on a sheet that determines the outcome
of the macros. When certain rows are hidden/unhidden based on a function,
the cell links of the option buttons/group boxes are being removed when
hidden/unhidden. Is there any way to ensure that the cell links do not
disappear? Perhaps there is a way to dedicate the cell link regardless of an
object/row being hidden or unhidden or visual basic that will assign a cell
link when the object is revealed?
I am working on a project where every row has a group box with option
buttons (form control) to drive certain macros. Each response generates a
summary of data (through cell links) on a sheet that determines the outcome
of the macros. When certain rows are hidden/unhidden based on a function,
the cell links of the option buttons/group boxes are being removed when
hidden/unhidden. Is there any way to ensure that the cell links do not
disappear? Perhaps there is a way to dedicate the cell link regardless of an
object/row being hidden or unhidden or visual basic that will assign a cell
link when the object is revealed?