Problems with Buttons (Excel 2010)

[Actuary_1]

Hi All,

I have a problem with buttons on the worksheet. I'm using buttons in my worksheet to open/close some rows. But, when I close a sheet, then all the buttons that are in hidden rows are collapsed (heigth = 0) and they are all moved to the first (lower) row that is not hidden. The buttons that are in a non-hidden row, get expanded over all hidden rows.

For example (image):
http://postimage.org/image/2tr8k61ac/

This is very annoying, because the only way I've found to fix this, is to resize all the buttons and drag them to their correct position again (and some of my sheets have >50 buttons).

Has anybody seen this before? And is there a way to keep this from happening?

I'm using Excel 2010 and it only occurs in this version. This problem does NOT occur in 2007 (or earlier) version(s). So, it probably has to do with a new 'feature' or something...

Please help. I'm getting tired of fixing the buttons in all my sheets

ADDITION:
I already found a way around this problem. On close I run a macro that unhides all rows. On open I run a macro that hides certain rows. This works fine untill, for some reason, the BeforeClose doesn't run (a Excel crash for instance), then the buttons are all messed up again...

 

[RoryA]

There have been a lot of mentions of this kind of problem in various forums and it has been mentioned to MS. Do you have SP1 in place, as a matter of interest? (I don't know if it fixes it, as I generally avoid controls on worksheets)

 

[Datsmart]

Have you tried setting your button properties "Don't move or size with cells"?

I don't have version 2010 so don't know if this will make a difference.
This may not work for you if you want some buttons to hide along with the hidden rows.

I agree with Rory, maybe that many buttons is not the way to go.

 

[Actuary_1]

I have installed SP1, so there's no fix in that SP.

And I agree with you. If I would have made the sheets I would have done it differently, but unfortunately the sheets were already being used (for years) when I started at this job. With no problems, because they didn't used Excel 2010 then. Right now, only a few people are using 2010, but before the entire company upgrades, this has te be fixed...

Fixing this would probably be faster then thinking up a new method and applying in to all the sheets that are being used (>>100 sheets)

And I've tried the 'dont size button' thing. But that also doesn't solve the problem...