Picture Export Not Functional from Button

Hello All,

The issue I am having is that my code works perfectly when I step through it in the VBA window but when I assign the same macro to a button and run it from the sheet it doesn't work properly.

I am copying a group and pasting it as a chart object for exporting as an image, but when I am running it off a button the image is blank. When I run each step in the VBA window it exports with the image in it properly.

My code is as follows:

Please Login or Register  to view this content.

It seems to not be recognizing/performing the "chtObj.Chart.Paste" operation. I have attempted to add some wait operations in there in case it was running through lines faster than my computer could keep up, that's also why I have screenupdating = False.

Any help on how to resolve this issue would be greatly appreciated.

Thank you.

Your code works for me even when running from a button. So I'm not sure what the problem is. I seriously doubt the code is running too fast for your computer. VBA doesn't work like that.

Here's your same code cleaned up a bit. I didn't change any methods, but maybe it somehow it fixes the issue.

Please Login or Register  to view this content.

Originally Posted by DarkF1ame

I have inserted this code to my spreadsheet and it continues to not function when fired from a button.

I recently upgraded to Office Standard 2016, do you think that may have any bearing on the situation?

I found this thread with the same issue.
https://www.mrexcel.com/forum/excel-...mpty-file.html

Bottom line; he says Activating the chart cured the problem.

Please Login or Register  to view this content.