How can I block copy paste the graphs?

[akinkaraman]

Dear Excel Ninjas, how can I block copy paste the graph to another page or to another excel file and hide the formulas on the graph?

 

[Faseeh]

Have you seen this:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

..and

http://www.techonthenet.com/excel/cells/hide_formulas2007.php

 

[akinkaraman]

Very good macro to block cut, copy, paste but it works on cells; I can still copy the graph and paste it into a new excel file.

Lock and hide cells also work on cells, I still can see the formulas on the graph.

 

[Khalid NGO]

Hi,
When you protecting your sheet, un-check the following 2 checkbox:

Edit objects
Edit scenarios

Regards,

Edit:
It shows after copy/past cells to new sheet

 

[akinkaraman]

It worked. Thanks Khalid.

I was looking for the answer of this question at internet for 2 days.
Nobody tells.

I am appreciated.