Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hidden column becoming unhidden upon forwarding Concerned friend Excel Discussion (Misc queries) 2 November 17th 09 08:23 PM
CheckBoxes Stack up when Rows are hidden and unhidden Goldenfoot Excel Worksheet Functions 19 February 13th 09 05:41 PM
How do I protect hidden rows from being unhidden? Pam P Excel Worksheet Functions 5 December 15th 05 08:49 PM
Why are my hidden rows unhidden after I edit a graph? JazaJoswick Charts and Charting in Excel 0 August 12th 05 09:24 PM
Hidden Columns are unhidden when inserting a Formula Andy Excel Discussion (Misc queries) 0 April 4th 05 08:16 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"