ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Links disappear when objects are hidden/unhidden (https://www.excelbanter.com/excel-programming/430548-cell-links-disappear-when-objects-hidden-unhidden.html)

Andy S[_2_]

Cell Links disappear when objects are hidden/unhidden
 

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?


All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com