How to protect or lock only a few chards (objects), but not all of them?

Dear all,

How can I lock or protect only a few chards instead of them all?

If I go to the protection function, I now have allowed all users to only edit the objects.
My target is to let them only edit a few objects (the slices), but not to let them edit all of the objects (the chards may not be editted).

Does someone know the solution?

I'm not sure what type of shapes you are referring.

However you can set the protection for most shapes by right clicking, selecting Format..., then goto
Properties where you can set the Locked or, for some shapes, Lock Text as required.

Ah thank you! I found the function, but when I tick or untick the "lock" function in the selecting format, properties page, nothing happens! I still can edit everything in the chard/object if I want to.

About the shapes: I used bar graphs and slices which are linked to the bar graphs. I want people to be able to use the slices, but not to edit the graphs.

Are you protecting the sheet after changing the properties of the charts/slices?

Ah I'm sorry, I now see what you mean! Yes, it's working!
But.. unfortunately, I see I do not have the unlock option for the slices... Only for the graphs. I now only can do the opposite of what I want to do. Now I can lock the slices, so people are able to edit the graphs. I just want to do the opposite: let people be able to edit the slices, but not the graphs.

Do you know how to "unlock" the slices?

I'm not too familiar with slicers, which is what I assume you mean.

I'm sorry, yes I mean slicers!

Hmm unfortunately.. But thank you for your effort!
It's strange that excel sees slicers as well as the graphs as objects, but that they nevertheless have a different properties menu.

Actually, I've used slicers but not for some time.

I just set one up connected to a pivot table, when I right click I can goto Properties and clear the Locked option.

Then when I protect the worksheet I can use the slicer, though it doesn't really work because the pivot table can't be changed.

If your slicers are for charts perhaps you won't have that problem?

I know what you mean. Thanks for trying.
All the slicers and charts are linked to pivot tables on another sheet. If I protect the pivot tables, the slicers and graphs cannot be changed indeed! I just hided the sheet with the pivot tables, so the chance will be little people "unhide" these and edit the pivot tables. I dont know another way...
The most important thing is that the graphs are protected as well. I cannot find the locked option if I right click on the slicers, but only if I right click on the graphs...

Where can you find that " use the pivot table reports" option? I can't find it in the sheet protection function... Does this also work if my graphs and slicers are in a different sheet than the pivot tables you think?

By the way, I'm sorry, but I'm using a Japanese version of excel. I have to do everything by heart, because I cannot read the characters/words/functions on my excel program. A good explanation of the location of a function would be really really appriciated !!

It's right at the bottom of the list, I might have the name slightly wrong but it definitely has 'Pivot table' in it.

Just checked, it's 3rd from bottom below Use Autofilter and is called Use PivotTable reports.

You should use that option on the sheet the pivot tables are on, if you are going to protect that sheet.

Thank you!! I found it, it works in the pivot table sheet, but I still have the same problem in the sheet with the slicers and the graphs! This is, because excel sees slicers as objects and not as autofilters or pivot table reports.. =(

Oke, just a summary :

I now protected the pivot tables and hided the sheet. I have my bar graphs together with the slicers on the other sheet (sheet 2). I also want to protect this sheet, but people still need to be able to change the slicer selections (so the graphs on sheet 2 will change automatically together with the pivot tables on sheet 1).

Nevertheless if I protect the sheet, even with the functions "use auto filter" and "use pivot table reports", the slicers selections cannot be changed.. Only if I also select the "edit objects" option, the slicers selections can be changed, but then also the bar graphs can be edited (what I don't want). The slicers don't have a "lock" option to avoid this problem.

Wauw! It was just so simple! Maybe it was just because I couldn't read the image meant "properties". I was looking at the same image button as the one which means properties in the graph's menu.

Thank you a lot!!!!