When you want to apply a small tweak to the document, it must not take long to Protect chart lease. This sort of simple activity does not have to require extra education or running through manuals to learn it. With the proper document modifying tool, you will not take more time than is needed for such a quick edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it’s your first time making use of a web-based editor service. This instrument will require minutes to learn how to Protect chart lease. The sole thing required to get more productive with editing is a DocHub account.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying regardless of your previous experience with this kind of instruments. Create an account now and improve your productivity immediately with DocHub!
hi Im member Tracy from my online training hub in this tutorial were going to look at how we can use the worksheet protection and workbook protection to allow people to interact with this dashboard by selecting periods in the slicer but not actually delete anything or move anything around or make any changes to it so first of all lets just talk a little bit about workbook and worksheet protection now by default every cell in your workbook is protected as are all of the objects in your workbook now an object is something that hovers above your worksheet like this chart the slices any shapes pictures clip out that kind of thing anything thats not in the cell is an object so theyre all protected by default now protection only comes into effect when you protect the sheet or protect the workbook so until you click on those and set your protection theyre not actually protected so before you protect your worksheet you want to unprotect the elements that you want people to be able to in