On Nov 17, 10:46*pm, RJQMAN wrote:
I have a long and complex program that works perfectly in excel 2003
and 2007, but I suddenly found this evening that when it is loaded
into 2010, it crashes. *I have spent hours trying to understand why
and I keep running up against a wall. I have excel 2003 and 2007 on
one computer where I developed the program and tested with both. *A
user brought over her laptop with 2010 on it this afternoon
complaining the program would not run. She was right.

It seems to start OK, and the command buttons on the opening screen
work fine, once macros are enabled. *But as the program moves to the
next worksheet (by clicking the command button), trouble starts.

The new sheet has a lot of control buttons on it. *The program hides
many rows so that only a few of the buttons are displayed. *The
buttons are radio buttons, command buttons, etc. When you try to open
this worksheet, the program goes crazy - but only with excel 2010. *It
worked fine with 2003 and 2007 on my computer and on others as well.
Plus I had one friend that had 2010 and it worked on her computer! *I
am completely confused and baffled.

When this sheet opens, most (but not all) of the buttons on the
worksheet suddenly move somewhere else, and then the program crashes -
I can't understand why they are moving, but that seems to be causing
the crash. When I step through the program, it hangs up at a statement
that tries to define the value of one of the buttons that has moved
somewhere- I have not even found it yet. *For all I know it may have
moved to another sheet.

I have the property for the buttons set at '1' with the intention that
they would be hidden if the row they are in is hidden. *This worked
fine in 2003 and 2007 on every computer it ran on. *I do not know what
to do and I am in trouble - the program is set to be used in two days
with a huge group of kids participating in a series of events (over
5,000 kids) at several school sites, and now I unexpectedly find that
some users that have excel 2010 cannot use it and I don't have any
idea how to fix it. *Can anyone help me? *I am in trouble.

Thanks in advance. *I hope someone can help...

I have been working on the problem for almost 12 hours. I think the
problem may be that some of the activeX controls are not really
attached to the cell that is hidden - they are attached to some other
cell, and therefore do not hide. I do not know how to attach them to
a specific cell. They seem to be 'attached' when using 2003 and 2007
with vista, but not necessarily when using 2010 with windows 7. Help
please...