Hey all,
After about an hour of searching I am stumped. Excel 2007 has a nice feature that when you select the plot area of a chart, right click, select Format Plot Area..., then select the Fill tab and select the "Picture or Text Fill" radio button, you have the option to hit a button and insert the image from the clipboard.
Now when I record this action with the Macro recorder it seems to stop recording as soon as I select the plot area. Being somewhat experienced in chart formatting I know you can select a fill image from a file like so:
ActiveChart.PlotArea.Format.Fill.UserPicture "C:/..........."
My question is basically can I do some sort of call to the clipboard:
ActiveChart.PlotArea.Format.Fill.UserPicture = CLIPBOARD PLEASE!!!
^That did not work by the way...
I am happy to get more complicated but praying this one is simple.
Thanks,
Joe
After about an hour of searching I am stumped. Excel 2007 has a nice feature that when you select the plot area of a chart, right click, select Format Plot Area..., then select the Fill tab and select the "Picture or Text Fill" radio button, you have the option to hit a button and insert the image from the clipboard.
Now when I record this action with the Macro recorder it seems to stop recording as soon as I select the plot area. Being somewhat experienced in chart formatting I know you can select a fill image from a file like so:
ActiveChart.PlotArea.Format.Fill.UserPicture "C:/..........."
My question is basically can I do some sort of call to the clipboard:
ActiveChart.PlotArea.Format.Fill.UserPicture = CLIPBOARD PLEASE!!!
^That did not work by the way...
I am happy to get more complicated but praying this one is simple.
Thanks,
Joe