Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Data from One Worksheet to Another | Excel Discussion (Misc queries) | |||
Automatically copying data into a new worksheet | Charts and Charting in Excel | |||
Copying filtered data to another worksheet | Excel Worksheet Functions | |||
PROTECED SHEETS | Excel Discussion (Misc queries) | |||
E-Mailing a Proteced Sheet | Excel Discussion (Misc queries) |