Protect worksheet and graphs

[bhos123]

I want to protect the worksheet which has graphs....

After protecting I want to allow user to copy the graphs for their PPTs.....but not edit graphs... any idea??

 

[Dermot]

I think this article has the answer

Protecting spreadsheet elements

Working with large and complex Excel workbooks, especially when entering large amounts of data, no one is protected from accidental changes in formulas, formats and other spreadsheet elements. But you can protect yourself from too much work on finding and eliminating such errors by protecting...

www.officetooltips.com