If you have the password you should have no problem in using it. Please
try the following steps.

In your excel session, open VISUAL BASIC EDITOR under the menu option
TOOLSMacroVisual Basic Editor (Alt+F11 also works).
You will see the project explorer window containing your project. You
can enter the password here and start working on your macros.

Hope this helps.