First things first, I myself am prety much just starting out with VBA. So with that said...
Two things could be happening That I can think of...
1. you are using the wrong name (should be in quotes) or variable.
or
2. You have mistyped the password.
This is one of my set-ups (password has been changed for my protection).
simple as this for unprotection.
And to protect
Password - states the password
DrawingObjects - protects any objects
Contents - protects locked cells
Scenarios - not to sure what these are but I left it in
UserInterfaceOnly - will not alow VBA to select a cell but VBA alown can edit the cells.
something you could do is
Bookmarks