command button on top
 

Hey guys

I have a chart I made from a pivot table. I want to make
it an interactive chart. When I draw a CommandButton on
the chart it dissapears when I click on the chart, then
reapears when I click off the chart. How do I make this
command button stay on top of the chart. I have tried to
right click the commandbutton and then select bring to
front and then right click on the chart and click send to
back, but these settings dont seem tom ake any
difference. Is there maybe another setting I am missing?
If not is there code to do it?


Thank you
Todd Huttenstine

command button on top
 

Charts don't support activeX controls. You will need to use a button from
the forms toolbar.

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
Hey guys

I have a chart I made from a pivot table. I want to make
it an interactive chart. When I draw a CommandButton on
the chart it dissapears when I click on the chart, then
reapears when I click off the chart. How do I make this
command button stay on top of the chart. I have tried to
right click the commandbutton and then select bring to
front and then right click on the chart and click send to
back, but these settings dont seem tom ake any
difference. Is there maybe another setting I am missing?
If not is there code to do it?


Thank you
Todd Huttenstine