Allow selecting but not editing a chart and slicers in a protected Excel sheet

خرید بک لینک

I would like to share an excel file that has slicers and charts in it. I want users to be able to use the slicers for filtering and then select and copy the charts. But I want to protect the sheet and prevent any editing of the chart and the slicers.
As far as I can see, the options are to lock the charts and slicers, in which case they are uneditable when the sheet is protected, but then the slicers are frosen and the chart can't be copied (PrintScreen is not an option). OR, to unlock them, in which case they become usable but editable.
Is there a way around this?

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 231 تاريخ: سه شنبه 1 تير 1395 ساعت: 22:39

صفحه بندی