Controls lose position

[Rob Standefer]

I have a workbook with 12 sheets. Several of the sheets have controls
on them (ActiveX option buttons and command buttons). The controls are
in ranges that get shown or hidden based on user input; when the range
containing the control is set to Hidden, the control's Visible
property is set to False.

The problem is, when I close my workbook and then open it again, all
the controls in hidden ranges are stacked on top of each other when
the ranges are shown. In other words, the Top property for the
controls is all set to the same value. It's like Excel forgot where
the controls were supposed to go. Has anyone experienced this problem?
Is there a fix or a workaround? I could keep track of Top in hidden
ranges but I'd really like to avoid that.

Any help is greatly appreciated. This problem has set me back several
days.

Thanks,
Rob

 

[Jamie Collins]

(e-mail address removed) (Rob Standefer) wrote ...

sheets have controls
on them (ActiveX option buttons and command buttons). The controls are
in ranges that get shown or hidden based on user input; when the range
containing the control is set to Hidden, the control's Visible
property is set to False.

The problem is, when I close my workbook and then open it again, all
the controls in hidden ranges are stacked on top of each other when
the ranges are shown. In other words, the Top property for the
controls is all set to the same value. It's like Excel forgot where
the controls were supposed to go.

Try changing the controls' Placement properties to equal 1 (xlMoveAndSize).

Jamie.

--

 

[Tom Ogilvy]

You don't mention printing or xl2002, but you might look at this as well:

http://support.microsoft.com/default.aspx?scid=kb;en-us;838910