I have protected my VBA project with a password to prevent users from
altering the code. My modules open MS Outlook and create a mail message
(amoung other things). All the code works fine until the user attempt to
close the workbook, when they are suddenly prompted for the password. The
password window can not be exited without the proper password. Why is this
happening and is there a way to trap this prompt and supply the password
programatically?

Everything I have read said that programatic setting of the password is not
possible.

Any suggestions would be appreciated.

Thanks