How to Remove a Password in Excel Macros

Written by lawrence stephens
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Remove a Password in Excel Macros
Passwords on Excel macros can be easily removed. (data security image by dinostock from

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.

Skill level:


  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

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

  5. 5

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

  6. 6

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

  7. 7

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.