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