Solved: Require password to use template

[clhare]

I need to set up a template so that the user can only run it if they have the password. I'm assuming I would add code to the AutoNew module, but I can't figure out how to set up the password code.

Any help is greatly appreciated!

[clhare]

I figured it out! I finally found something on the Internet that mentioned using a userform for the password (using the PasswordChar property to mask the password entered). I tried that and did an If statement to see if the password was entered correctly. If it is, the remaining macros in the template will run--if it isn't, they won't.

Yea!:biggrin: