Скачать с ютуб How To Protect or Lock Workbook Structure In Excel в хорошем качестве

How To Protect or Lock Workbook Structure In Excel

How to Protect or Lock Workbook Structure in Excel In this excel tutorial for beginners I’ll show you how you can protect workbook structure in Microsoft excel. I am using excel 2019 for the demonstration and we are not going to use any vba in this tutorial. We’ll just use built in excel function to lock workbook structure . Let’s say you have several sheets in your workbook. You ordered them to your preferred way. You’ve colored Sheet tab and Named your worksheets to your preferred name. Now this is worksheet structure. So, if you lock worksheet structure there will be several protections, you’ll able to give your workbook. 1. You can stop changing your worksheet name 2. Stop people from reordering your worksheets 3. Stop changing color of your worksheet tab 4. Stop users from creating new worksheet 5. Stop users from Copy/Move a worksheet 6. Prevent deleting your worksheet 7. Prevent others from renaming your worksheet 8. Prevent users from Hide/Unhide your worksheet Now you can still edit or change data inside your workbook. You can change worksheet formatting, insert data also you can do everything you want inside your worksheets except the above things. So, protecting worksheet structure helps you to maintain workbook and worksheet level formatting with limited access to other users. The most important thing is that you can unlock workbook structure with the password and you can do everything like a normal workbook. Now that you understand what workbook structure is let’s learn how to password protect workbook structure in Microsoft Excel without using VBA. There are two ways you can password protect workbook structure in excel. Here goes the first way to lock workbook structure 1. Click on File 2. Under the Info section click protect workbook dropdown 3. Click on Protect Workbook Structure 4. Checkmark Structure 5. Enter and Confirm Password 6. Click Ok and Done The second way of protect workbook structure is as follows 1. Click on “Review” tab 2. Click on Protect workbook 3. Checkmark Structure 4. Enter and Confirm Password 5. Click Ok and Done These were two ways you can access and use “Protect Workbook Structure” In Microsoft Excel. Make sure you remember the password you set otherwise you won’t be able to change your workbook structure. If your workbook has macro in it and it needs to change the structure you won’t be able to run that macro. Also, if you thinking this as your ultimate security measure then you should reconsider it. There are several tools that can break your password. But the good thing is that not everyone knows how to break excel password and you can give your workbook structure a but protection. #Protect #WorkbookStructure Thanks for watching. ------------------------------------------------------------------------------------------------------------- Support the channel with as low as $5   / excel10tutorial   ------------------------------------------------------------------------------------------------------------- Please subscribe to #excel10tutorial https://goo.gl/uL8fqQ Here goes the most recent video of the channel: https://bit.ly/2UngIwS Playlists: Advance Excel Tutorial: https://goo.gl/ExYy7v Excel Tutorial for Beginners: https://goo.gl/UDrDcA Excel Case: https://goo.gl/xiP3tv Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB Excel VBA Programming Course: http://bit.ly/excelvbacourse Social media: Facebook:   / excel10tutorial   Twitter:   / excel10tutorial   Blogger: https://excel10tutorial.blogspot.com Tumblr:   / excel10tutorial   Instagram:   / excel_10_tutorial   Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!    / @excel10tutorial