How to Remove a Password in Excel Macros
Microsoft Excel allows you to password-protect your macros in Visual Basic for Applications (VBA). This protects macros from being edited by unauthorized 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.
Other People Are Reading
Instructions
-
-
1
Open the Excel file from which you wish to remove the password.
-
2
Open the Visual Basic editor by pressing the "Alt" and "F11" keys simultaneously.
-
-
3
Enter the current password in order to view the project code.
-
4
Right-click on the project name on the left side of the window.
-
5
Click on "VBA Project Properties" and select the "Protection" tab.
-
6
Remove the check from the "Lock Project for Viewing" selection box. Near the bottom of the window, delete the current password.
-
7
Click "OK" to confirm your changes, and then save the document. The macro password should now be removed.
-
1
References
- Photo Credit data security image by dinostock from Fotolia.com
