Strange button behaviour

[Steve_in_Kent]

I have a graph (a whole tab).. have placed a form button on the graph to go back and forth in time. (code behind etc)

however, here's the strange thing.. when i click the button, the button moves to the right, each time.

how can i fix the position of the button ?

Steve

[steveh]

I have a graph (a whole tab).. have placed a form button on the graph to go back and forth in time. (code behind etc)

however, here's the strange thing.. when i click the button, the button moves to the right, each time.

how can i fix the position of the button ?

Steve

Hi Steve

Does right clicking the button and then setting the move properties to not move or size with cell help?

[HansV]

It's a chart sheet so the "Object positioning" property is not available.

I can reproduce the problem, it looks like a bug to me. A possible workaround is to add code to the macro that is run by the button:

Code: Select all

  With Charts("Chart1").Shapes("Button 1")
    .Top = 10
    .Left = 300
  End With

where Chart1 is the name of the chart sheet and Button 1 is the name of the command button, and with appropriate values for Top and Left.

[Steve_in_Kent]

Yea, think your right Hans.. excel bug!!! o my

will add the workaround as you suggest...!!

@Steveh. and just for anyone further reading this: Changing anyof the button properties doesn't help.

Steve