Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to prevent changes to the whole workbook?

In some special cases, you may want to prevent any changes to a specific workbook after you finishing the edit. The most direct and easiest way to handle this problem is to protect the whole workbook. But in Excel’s built-in utilities, the Protect Workbook just can protect the workbook’s structure and window. So how can you prevent any changes to the whole workbook?

Protect sheets one by one with Excel

Protect workbook with Kutools for Excel


arrow blue right bubble Protect sheets one by one with Excel


To protect the whole workbook from changing, you can protect its sheets one by one to achieve this goal.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

1. Click Review > Protect Sheet, and in the Protect Sheet dialog, enter the password for protecting the sheet, and then you can uncheck the operation in the Allow all users of this worksheet to section to prevent all users from doing changes. In default, a protected sheets only allow users selecting locked cells and unlocked cells. See screenshot:

doc prevent changes to workbook 1
doc prevent changes to workbook 2

2. Click OK, and reenter the password again, and click OK to finishing the protecting. See screenshot:

doc prevent changes to workbook 3

3. Repeat above steps to protect all sheets in the workbook.


arrow blue right bubble Protect workbook with Kutools for Excel

If there are several sheets needed to protect, above method maybe not boring for you, but how about hundreds and thousands of worksheets in a workbook needed to be protected? Kutools for Excel’s Protect Worksheet can quickly protect all sheets in a workbook.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Click Enterprise > Protect Worksheet. See screenshot:

doc prevent changes to workbook 4

2. A Protect Worksheet dialog pops out, and all the sheets in the workbook are listing in it, in default, all the sheet tabs are checked, and click Ok to go to the second Protect Worksheet dialog, and type the password into both the Password textbox and the Retype Password textbox, and then to specify the operations you allow users to do in the Allow all users of this worksheet to section.

doc prevent changes to workbook 5

3. Click Ok, and the whole workbook is protected from any changes by all users.

pay attention1If you are interested in this addi-in, click here to download the 60-days free trial.


Relative Articles:



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.