Encrypt Macro

[festivalsimmo]

Hi all,

I'm only recently learning about macros, so this may be an easy question to answer, but hopefully someone here can help.

I'm trying to build a macro into a workbook whereby when someone opens the workbook it's unencrypted, but when they click a "Submit" button, it automatically encrypts with a password I've generated.

So far I've created the macro and encrypted the workbook, but when I save it, it's encrypted the next time I open it, which isn't helpful. And when I unencrypt it myself, the macro loses the password.

I've just been using the "record macro" buttons, as I don't know anything really about scripting.

Any help would be much appreciated.

 

[festivalsimmo]

Just a quick bump cause this moved down to page 18 and an update.

I've also tried running a macro that automatically protects the worksheet and sends it...again, the trouble is that the password I set to protect the document vanishes in the macro. It protects the sheet, but without a password.