lock cells, but unlock graphs + excel 2007

[jschill2628]

Is there a way in Excel 2007 to lock cells, but allow users to copy and paste graphs.

What I mean is I have national data, for a time frame,and I want to lock these cells, so my hospitals cannot change it. I have another line where they are able to enter in their own data. So my question comes from, if I lock and protect the workbook, they are able to enter in their data (for comparison purposes), but they cannot "grab" or copy the graph the the workbook creates.

Is there a way around this?

Thanks in advance!!!

 

[SkipVought]

hi,

How about Edit Objects in the Protect Sheet Window?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]