Chart creation in Shared Workbook

Hello,

I have a Userform that generates a Chart on a sheet, then using the method of creating a GIF file from that Chart, vba then places the GIF file into a Image place holder on the Userform. However, when the workbook is Shared, creating charts is not possible. To get around this I turn off sharing while the chart is being generated, then turn on sharing once the operation is complete. I can only use this method if no one else has the workbook open and do not prefer to do it this way. I want to pass the chart to another workbook called "TempChartWB.xlsx" and create the GIF file from the temporary workbook. Is there a way to modify the following code to do this?

I also attached a screen shot of the Userform below.

Please Login or Register  to view this content.

Frequency Chart.jpg


Thanks for the help!

BigD

Anyone????