Moving protected graphs

G

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
 
G

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
 
G

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top