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

On Thu, 26 Mar 2009 10:24:36 +0000, Graham H
wrote:

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