How to Change a VBA Passwordby Ty Arthur
VBA (Visual Basic for Applications) is a programming tool integrated into Excel, Word and the other Microsoft Office programs. VBA lets you use Visual Basic coding to change your document and add extra features, such as running repetitive tasks automatically. You probably don't want any other user to be able to directly modify your code, which may cause serious problems with your documents. To keep your code safe, the Visual Basic editor gives you the option to create and change a VBA password.
Open the Microsoft Office document that has the VBA password. Select the "Developer" tab, which is positioned at the top-right end of the window.
Click the name of the appropriate worksheet at the left side of window, if you are changing the VBA password in an Excel document. Click the "Tools" button at the top of the window and select the "VBA Project Properties" option.
Navigate to the tab labeled "Protection." Click the "Lock Project For Viewing" check box, if it isn't already checked.
Highlight the string of "*" symbols in the "Password" box and hit the backspace key. Type the new password you want to use in the box. Delete the text in the "Confirm Password" box and re-type your new password.
Click "OK." Open the "File" menu and choose "Save." Close and then re-open the document to save the new VBA password.
- The "Developer" area is not displayed by default in Microsoft Office 2007 and Microsoft Office 2010. Click the "Microsoft Office" button at the top of the screen if the "Developer" tab isn't visible. Click the button marked "Excel Options," "Word Options" or "Access Options," depending on the program you are using. Mark the "Show the Developer Tab" box and click "Apply."
- The new password doesn't take effect until you completely close down and then re-open the document.