Copying data from a proteced worksheet
 

I have a database which is accessed on a daily basis by my team members.
Because of the hard work that I have put into it, I keep it "protected" with
a password, to prevent any of my formulae or formatting going "funny". I do
however need my team mates to select and copy some of the graphs that I have
placed in this database. I find that when I protect the worksheet with the
graphs on it, it is not possible to select or copy any of the graphs, in
spite of me checking both the "Select Locked Cells" and "Select Unlocked
Cells" options under the "Protect Sheet" option? How can I keep my data
protected and still allow the graphs to be selected and copied?

Copying data from a proteced worksheet
 

When protecting, also allow "Edit Objects"

Second from bottom on list.


Gord Dibben MS Excel MVP

On Mon, 23 Mar 2009 22:01:01 -0700, WildWill
wrote:

I have a database which is accessed on a daily basis by my team members.
Because of the hard work that I have put into it, I keep it "protected" with
a password, to prevent any of my formulae or formatting going "funny". I do
however need my team mates to select and copy some of the graphs that I have
placed in this database. I find that when I protect the worksheet with the
graphs on it, it is not possible to select or copy any of the graphs, in
spite of me checking both the "Select Locked Cells" and "Select Unlocked
Cells" options under the "Protect Sheet" option? How can I keep my data
protected and still allow the graphs to be selected and copied?