Disappearing buttons and drop down lists in Excel 2010

[__Steve__]

I have just came across very annoying problem with Excel 2010. All buttons and drop-down lists disappear from hidden rows after saving and reopening any worksheet. At home I am using Excel 2007 and it works fine, but unfortunately at work we are using excel 2010 which just does not work as it should. Does anyone of you know how to solve the problem with disappearing drop downs and buttons?

 

[__Steve__]

I think I've just came across one of possible ways around that problem. All form controls should not scale or move with cells. The trick is instead of scaling and moving them with hidden rows a macro to hide them could be used, maybe something like this:


If CheckBoxAnnualIncrease.Value = False Then
FrameRentIncrease.Visible = False
LabelYear1Rent.Visible = False
Else
FrameRentIncrease.Visible = True
LabelYear1Rent.Visible = True
End If


What do you think? It should work and that would be a possible solution to the problem with disappearing form controls when hiding and unhiding rows.