Good thought. That was one of the things I tried, and there is a formula
that is dependent on the cells but it merely checks to see if filled out.
This is also done on every other yes/no question.
Thanks for the suggestion.
"JLGWhiz" wrote:
A little late now, but if it happens again, check the precedients and
dependents to see if they have links for other than the option buttons.
"JNW" wrote:
Unfortunately I am using the events. I got it to work by inserting a new row
and moving everything to that row. It appears as if there was something
trapped in Excel's memory having to do with those particular cell
references...
"Leith Ross" wrote:
Hello JNW,
In my experience, it is never a good idea to use linked cells with
ActiveX objects on a worksheet. There seems to be an inherent
communication problem. If you don't need the event capabilities of the
ActiveX control, use a Forms Toolbar control instead.
Sincerely,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48332