vba enter password everytime i activate workbook

[daveyc18]

so i open a workbook via vba code and it's password protected

the opening code i know i can put , password:="password" to skip the prompt, but everytime i go back to activate the password-protected workbook (e.g., "rps.activate"), it asks me for the password again

how would i enter the code in this case?

 

[daveyc18]

interestingly, if i just clikc "ok" or "cancel" without entering a password, the code proceeds.....