On Sun, 24 Apr 2005 01:57:46 GMT, "daniel chen"
wrote:

Hi Hank,
I need to enter data in the worksheet that contains the activated chart.

Yesssss... and?

All you do is specify the range that you want to enter the data into,
and use the .Select method as originally illustrated.

(In fact you don't even need to specify the exact range if the macro
itself is doing the entry; all you need to do is use the .Select
method on a range... ANY range or cell... which will make the
worksheet rather than the chart active. You can then do your data
entry.)

"Hank Scorpio" wrote in message
.. .
On Sun, 24 Apr 2005 00:34:44 GMT, "daniel chen"
wrote:

My workbook contains charts.
If I had one of these charts activated, I could not execute Macros.
Please help me with a VBA code to de-activate them.

Regardless of whether the chart is in a chartsheet or on a worksheet,
this should point you in the right direction:

Sub DeselectChart()

'Select any non-chart sheet
Sheet1.Select

'Or if the chart's on the current sheet, this'll do it.
Range("A1").Select

End Sub

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *