DISCOVER
×

How to Remove a Password in Excel Macros

Updated April 17, 2017

Microsoft Excel allows you to password-protect your macros in Visual Basic for Applications (VBA). This protects macros from being edited by unauthorised users. If the data in a macro no longer needs to be protected, you can easily remove the password so that other users can view and modify the macro.

Open the Excel file from which you wish to remove the password.

Open the Visual Basic editor by pressing the "Alt" and "F11" keys simultaneously.

Enter the current password in order to view the project code.

Right-click on the project name on the left side of the window.

Click on "VBA Project Properties" and select the "Protection" tab.

Remove the check from the "Lock Project for Viewing" selection box. Near the bottom of the window, delete the current password.

Click "OK" to confirm your changes, and then save the document. The macro password should now be removed.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Lawrence Stephens has been writing professionally since 2008. He has written on a variety of topics for newspapers and websites, including Bizcovering and "The Harbor Sound." He has worked as a ghostwriter in fiction and nonfiction. In addition to writing full time, he is working toward a Bachelor of Science in computer programming from the University of Phoenix.