Well,
Or you just wait for the password question, or you write the password in your script.
You do not have to place the script in the same location as the sheet.
You can also obfuscate the password by per example tokenizing (kix32 /t).