"Roxy" wrote:
> Thank you for your quick responses.
> When I copy and paste the exacty as it is from the website it get an error
> message "Password Incorrect", because I have my forms protected with a
Don't tell me you pasted the code exactly as is without editing it to use
*your* password... Have you changed "Password" to "colleen"?
> password that only I the creator will know and none of the users will know.
> I thought you need to program into the code with the password to unprotect,
> run spellcheck, reprotect so the user doesn't get asked what the password is.
> Am I incorrect?
Not quite. If you use the correct password in the code, all you need is
protect the document manually using that password; then the code will work.
Of course, if you use password A when locking up the form and then using
password B in the code, it won't work... Or, if you use Password A to
unprotect, and then Password B to protect, the next time the code runs, it
won't work either...