Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP - Radio buttons and other controls suddenly moving in Excel 2010 only
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping Radio Buttons; Using ActiveX Controls | Excel Discussion (Misc queries) | |||
how do I get radio buttons in excel | Excel Discussion (Misc queries) | |||
How do I stop radio buttons moving left after Printing | Excel Discussion (Misc queries) | |||
Radio buttons moving when spreadsheet is viewed on other systems | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |