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! *