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 Fotolia.com)

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:
Easy

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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