Forum Discussion
jtfnash
Apr 03, 2024Copper Contributor
Protection
I have a workbook which has slicers and timelines on it. I would like to be able to protect the worksheet but allow the use of the slicers and timelines while it is protected. Is this possible?
- Here is a way you can get that outcome that I just tested and does work: Create a Microsoft 365 Group (one that allows guests) and adding your volunteers as members of that group by their email address. Creating a Group gives you a SharePoint site and you can create news from that site and send it via email to all the members - whether they are internal or external. They will also have access to all of the other content on the site as members of that Group. But, if you wanted to share news that is hosted on another site, like your intranet home page, that site does not actually have to have external sharing enabled - and it probably shouldn't. What you would do is use Promote on an individual article to send it to the group via email. If the article is coming from a site that the users have not been added to (as Visitors or Members - which WOULD require external sharing to be enabled if it is a communication site), they will see the email but not be able to click on any links that point to the source site - because they don't have access to the source site. If you use a "made for email" news template to create the post, they will get the full content of the page, not just a summary. There will be a link at the bottom of the page that says View in SharePoint - but this won't work for them because they are not guests on the source site. I think this approach will get you your outcome (with an initial set-up step). Just one thing - when you create the group, everyone you invite will get an email inviting them to the group. If you don't want that to happen, I think there is a PowerShell script you can run to prevent it. So, to sum up, there is not a direct way to send an email of a SharePoint page outside the company, but if you have created a group and added them as a guest member, you can send to the group and they will get the email in their "home" email account.
2 Replies
Sort By
- NikolinoDEGold Contributor
It’s possible to protect a worksheet in Excel while still allowing the use of slicers and timelines.
Here is how you can do it:
- Protecting the Worksheet:
- Go to the "Review" tab on the Excel ribbon.
- Click on "Protect Sheet" in the "Changes" group.
- In the "Protect Sheet" dialog box, you can set a password if desired and choose which elements of the worksheet you want to allow users to modify while the sheet is protected. Make sure to uncheck "Select locked cells" to allow interaction with slicers and timelines.
- Click OK and enter the password if you set one.
- Setting Slicers and Timelines to Be Unlocked:
- Before protecting the sheet, ensure that the cells containing slicers and timelines are unlocked.
- Select the cells containing the slicers and timelines.
- Right-click and choose "Format Cells."
- In the "Format Cells" dialog box, go to the "Protection" tab.
- Make sure the "Locked" checkbox is unchecked. This ensures that these cells remain unlocked even when the worksheet is protected.
- Click OK to close the dialog box.
- Protecting the Workbook:
- Once you have set up the slicers and timelines to be unlocked, proceed to protect the worksheet following the steps outlined above.
By following these steps, you can protect your worksheet in Excel while still allowing users to interact with slicers and timelines. This allows for data exploration and analysis while maintaining the integrity of the worksheet. Make sure to test the protection settings to ensure they meet your requirements before distributing the workbook. The specific commands and interface elements may vary slightly between versions, the general concept of protecting the worksheet and unlocking specific cells remains consistent across Excel versions. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
- jtfnashCopper Contributor
NikolinoDE Fantastic just what I needed thanks.