I have a client that has MS Excel 2000 bar charts made from worksheet data
series.
He wants to be able to click on a chart object such as a bar and have the
source data come to the front.
I have tried to put buttons over the chart but I can't change the button
color to match the chart.
I can change the chart bar to be the gray color of the button but that is
not desirable.
Is their a way to send the button to the back behind the chart and still get
the button to respond to a click?

Is there any way to turn a worksheet cell into a button?
The only way I can see is to place a button over a cell and make it
transparent with no caption.
Also there seems to be no way to change the button border to transparent or
match cell.

I have used a ActiveX button, but also tried a Form button.
The ActiveX is switched from design to run mode via the Control Toolbox
Design Mode button.
But the Form button remains in design mode. How do I get it out of design
mode?

Sorry for all the questions. Have search Help but can't get answers.

Skillman Hunter

Hi,

Read Jon Peltier's article on chart events.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

Cheers
Andy

Skillman Hunter wrote:
I have a client that has MS Excel 2000 bar charts made from worksheet
data series.
He wants to be able to click on a chart object such as a bar and have
the source data come to the front.
I have tried to put buttons over the chart but I can't change the button
color to match the chart.
I can change the chart bar to be the gray color of the button but that
is not desirable.
Is their a way to send the button to the back behind the chart and still
get the button to respond to a click?

Is there any way to turn a worksheet cell into a button?
The only way I can see is to place a button over a cell and make it
transparent with no caption.
Also there seems to be no way to change the button border to transparent
or match cell.

I have used a ActiveX button, but also tried a Form button.
The ActiveX is switched from design to run mode via the Control Toolbox
Design Mode button.
But the Form button remains in design mode. How do I get it out of
design mode?

Sorry for all the questions. Have search Help but can't get answers.

Skillman Hunter

You can make a rectangle that responds to clicks by assigning a macro to it.
The rectangle can be formatted much more flexibly that a button, you could
even make it transparent.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Skillman Hunter" wrote in message
...
I have a client that has MS Excel 2000 bar charts made from worksheet data
series.
He wants to be able to click on a chart object such as a bar and have the
source data come to the front.
I have tried to put buttons over the chart but I can't change the button
color to match the chart.
I can change the chart bar to be the gray color of the button but that is
not desirable.
Is their a way to send the button to the back behind the chart and still
get the button to respond to a click?

Is there any way to turn a worksheet cell into a button?
The only way I can see is to place a button over a cell and make it
transparent with no caption.
Also there seems to be no way to change the button border to transparent
or match cell.

I have used a ActiveX button, but also tried a Form button.
The ActiveX is switched from design to run mode via the Control Toolbox
Design Mode button.
But the Form button remains in design mode. How do I get it out of design
mode?

Sorry for all the questions. Have search Help but can't get answers.

Skillman Hunter