I'm not an expert by any means, but stumbled across a macro that referred to the password as "password" It would take a better hacker than me to get any farther than that!
It worked on one sheet, not on another. The fields you are trying to change are probably linked to the PSW - Part submission warrant. Type it in there. If you don't need the other worksheets for what you are doing, just delete them and keep the one you need and the PSW.
It is a great file - thanks Howard.