Tagged in:, , Comments: YourThoughts?

How To Unprotect An Excel Workbook

When you develop a workbook in Excel you have the option of protecting the contents from being changed inadvertantly or accidently. This can happen in many ways. You yourself can be working in the workbook. Dragging and dropping or cutting and pasting and ooops! All the calculations are gone.

Or, if you've developed the workbook for others to use and don't want them to change the inner workings of your workbook, protecting it is a great option to have.

However, when you need to remove that workbook protection in Excel, you can unprotect an Excel workbook like this.

First, open the workbook you want to remove protection from and go to the "Tools" menu. Run your mouse down to "Protection" and select what you need to do. That is "Unprotect Workbook".

If there is password protection you'll need to enter that password in order to unprotect your workbook.

Just click OK. You're done!



No comments

This article has no comments. Be the first and add your own comment!

Leave a comment





Some things to think about...

  • Please keep comments related to topic. Please be nice. Please don't spam!
  • Basic HTML tags are allowed:
    <a href> <abbr> <acronym> <blockquote> <code> <em> <strike> <strong>
  • Add your comment and click "Preview". If you're satisfied, click "Submit"
  • Just A Note: un-related or spam comments will be deleted.
  • Thanks!


Back To Top

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.