PC Review


Reply
Thread Tools Rate Thread

Cell Links disappear when objects are hidden/unhidden

 
 
Andy S
Guest
Posts: n/a
 
      30th Jun 2009

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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hidden column becoming unhidden upon forwarding Concerned friend Microsoft Excel Misc 2 17th Nov 2009 08:23 PM
Hidden queries are unhidden sam.alame@gmail.com Microsoft Access VBA Modules 0 3rd May 2007 04:42 PM
How do I protect hidden rows from being unhidden? =?Utf-8?B?UGFtIFA=?= Microsoft Excel Worksheet Functions 5 15th Dec 2005 08:49 PM
Protecting hidden columns so they can't be unhidden ? Gary Microsoft Excel Discussion 3 2nd Jun 2004 07:55 PM
Hidden columns that can't be unhidden Don Microsoft Excel Misc 3 17th Jul 2003 01:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:14 PM.