I have some VBA code that selects a worksheet, then changes the value of
some cells on that worksheet.

That worksheet has some charts that reference those cells.

If a user inadvertently has one of the charts selected when the macro is
run, I get an error (Runtime Error "1004").

If the chart was not initially selected, the code runs fine.

What is a good way to prevent this error? Is there a simple way to first
deselect any charts?

Using Excel 2000.

Thanks,

-- Rev