code to deselect a chart modified by VBA

B

Brad

I have a series of charts on a dedicated chart worksheet with attached VBA
routines to change various inputs for each chart. At the conclusion of the
VBA work, it leaves the chart just worked on "selected" ... with the clear
circles at the corners and chart mid-points indicating such, not the solid
circles.

I tried adding a terminal line in the VBA code, ActiveChart.deselect, and
got an error message. And, I tried ActiveSheet.Shape("Chart 733").Deselect
with the same outcome for a chart named as such.

My thanks in advance for the code I need to add to deselect my charts.

Cheers! Brad
 
P

Peter T

Just to add -
it leaves the chart just worked on "selected"
Click to expand...

If "just worked on" means by your code, you are probably including
unnecessary Activate or Select statements that can be removed thereby
leaving user's original selection unchanged.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine if a chart is embedded or not 7
VBA Public Function - Excel to PPT Stacked Chart, How to Remove Legends 0
VBA code to check if a custom chart exists 0
Error changing cells in VBA if a chart is active 1
VBA Code to move DataLables to top of Chart 4
What VBA Stmt Will Deselect a Chart? 2
VBA: Adding contents of a cell to a chart as a textbox (or image, 5
Smoothing a chart line using VBA 1

Top