Written by Allen Wyatt (last updated December 7, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
Dennis has a travel expense worksheet that he has inherited; it has been passed down within his organization for years. Some of the cells in the worksheet need to be unlocked so that Dennis can correct the outdated formulas they contain. There is the problem, though: The worksheet is locked, and changing the formulas is not permitted because of the protection. Dennis wants to know how he can unprotect the worksheet so he can make the necessary changes.
Depending on the way that the worksheet was protected, you may be able to simply copy the worksheet contents to a new worksheet. Follow these steps:
The new worksheet can be changed in any way you need. If the old worksheet has links to other worksheets, you may need to copy those separately or establish those links manually. You will also need to adjust row heights and column widths, as necessary, to match the old worksheet.
If the above doesn't work, for some reason, you will need to actually try to crack the worksheet password. There are macros available, on the Internet, that will remove or identify any internal passwords, such as those used to protect a worksheet. If you do a search for "Excel password cracker" or something similar, you will find lots of candidates. The problem is that you'll also get lots of search results for programs that remove workbook passwords—something you don't need for this particular purpose.
Let me save you some trouble, however. There is a perfectly good internal password remover that is available at this page:
http://www.mcgimpsey.com/excel/removepwords.html
The page explains the macro (which is rather long) and even provides a download you can use, if desired.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2776) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Unlocking a Worksheet with an Unknown Password.
Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!
Need to know if a worksheet or workbook is currently protected? Excel provides some tell-tale signs, but here are some ...
Discover MoreOnce you protect a worksheet, you may run into problems with any combo boxes that the worksheet contains. This is a ...
Discover MoreIf you have a worksheet protected, it may not be immediately evident that it really is protected. This tip explains some ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-02-07 11:01:52
Babak
Dear Allen Wyatt,
Is this McGimpsey code valid for 64-bit Excel?
Thank you
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments