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

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

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

Gord Dibben wrote:
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

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Graham H" wrote in message
...
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

Gord Dibben wrote:
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