Ok, I'm building a macro that resides in my master template and then creates a new workbook. To which it then copies each specified tab and does a paste values only along with the formats into each of the new tabs and renames the tabs. Basically, I'm creating a "dumb" sheet so my sales & marketing guys cant jack it up.
What I'm running into is that there are a few charts that aren't being copied when I select the whole sheet and I'd like to paste them into the new workbook as pictures... for example, if you copy a chart and paste it into another Excel sheet it'll pull all of the source links, but if you paste into Word, and then cut it out and paste it into an Excel worksheet it automatically becomes a picture. Is there a way to do this programmaticly? I've tried to record macros several different ways, but it always ignores the paste into Word part, it's like it doesn't happen. Anyone have a tip or a point in the right direction?
Thanks!
Chad
Bookmarks