Скачать или смотреть 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