Hi,

Have you set the property 'Do not size with chart' for the controls?

Cheers
Anyd

Andy the yeti wrote:
Hi,

I have a chart in its own tab with 6 buttons that run macros to other areas
of the work book and two drop down boxes that control what metrics are seen
in the chart. My problem and question is that when I change the combo box's
the buttons and boxs all move around slightly, leaving me with a messy
looking chart area.

Is there a way to lock them down to stop them from moving??

Thanks for any help

Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info