Deactivate chart created with VBA

I've programmically created a chart on the fly in Excel 2007. I'm running into an issue with the chart "deselecting" after being created. If I step through my code it all works with no issue, however if I let it run on its own the range selection at the end does not actually happen. Any ideas?

Please Login or Register  to view this content.

You shouldn't need to select it in the first place:

Please Login or Register  to view this content.

I was able to assign the action without selecting the chart, however I do have to have the chart active in order to change the series properties. After which the chart does not deactivate, unless I step through the code line by line.

Updated code:

Please Login or Register  to view this content.

Originally Posted by kcaprik

I was able to assign the action without selecting the chart, however I do have to have the chart active in order to change the series properties.

why? Did you try my code at all?

Also, can you please put code tags round your code, per the forum rules?

you type:
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

I don't see how you could have the same issue with my code since it does not select the chart at any point.

kcaprik, please take a moment to look at the forum rules and then edit your posts to add code tags.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I'm not sure what you are running, because I've tested it and it does not activate the chart and nor would I expect it to. Can you post the exact code you are using from start to finish?