Moving protected graphs

[Graham H]

I have a workbook which details some of the dtat in graphical format. The workbook is
basically an anylytical tool for accounts. The data and graphs are all protected so no one
can modify them. However what I would like ideally is that if someone is writing a report
in Word for example they can copy a graph from the workbook and paste it into the report.
While it is protected I am unable to do this. Is their any simple way to do this without
unprotecting the graphs? I would value any guidance.

Graham

 

[Gord Dibben]

Not without unprotecting or having protection set to allow users to "Edit
Objects" which would allow users to change chart attributes...........you
don't want that.


Gord Dibben MS Excel MVP

 

[Graham H]

Thanks for that Gord. I thought there was no shotcut. I have put in buttons for users with
code to copy the chart to the clipbord after unprotecting then reprotecting which I think
should work fine. Many thanks for responding.

Graham

 

[Jon Peltier]

Since you're using code (buttons), you can use this syntax to copy a chart
without selecting it:

ActiveSheet.ChartObjects(1).Chart.ChartArea.Copy

Or even better:

ActiveSheet.ChartObjects(1).Chart.CopyPicture xlScreen, xlPicture

which copies the chart as a picture, without links to any data.

- Jon