Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA macro passwords

Status
Not open for further replies.

MigrantFirmWorker

Programmer
Apr 9, 2003
54
US
How do I remove a password from a VBA macro? I know the password. I just want to get rid of it.
 
When your in the Visual Basic Editor make sure your Project Explorer is visible (if not, do "View/Project Explorer"). Right click on the project in question that has the password. Choose "VBAProject Properties". You might need to enter your password here to continue. Click on the "Protection" tab. Remove the password and uncheck the "lock project for viewing".

Hope this helps,
TopJack.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top