0
Thanks

A few words of thanks would be greatly appreciated.

Use a Macro to Unlock a Password Protected Sheet in Excel

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a password. Sometimes the password-protected sheet cannot be opened. A specific command or keywords need to be typed in to create a macro in Excel. This can be done through the visual basic editor of Excel. Users can unlock password-protected sheets with a simple syntax. After unlocking, all the official calculations and tasks can easily be performed. This option will help the user to maintain privacy.



How to Unlock a Password Protected Sheet

The syntax is quite simple:
ActiveSheet.Unprotect ("MyPassWord")       
'instructions
ActiveSheet.Protect ("MyPassWord")

For more details, I suggest you type "worksheet.protect" and "worksheet.unprotect" in the help file of visual basic editor.

Also try this syntax:

ActiveSheet.Protect PassWord:="MyPassWord", DrawingObjects:=True,  _        
Contents:=True, Scenarios:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True


Photo by Thought Catalog on Unsplash
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « Use a Macro to Unlock a Password Protected Sheet in Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).