Code To "Save As" And To Prompt To Enter A Password To Encrypt The Document?

[npsnps]

Hi,

I have made the below code (Ive just found out it doesnt actually "save" so im missing a line or two somewhere).

It brings up the Save As box and the file name is taken from certain cells in the workbook, what I need is before this save as box comes up it prompts the user to input their own password to encrypt the document so wherever it is eventually saved to, no-one will be able to open it without the password that was entered.

Is this possible?

Thank You

Please Login or Register  to view this content.

[Olly]

Try:

Please Login or Register  to view this content.

[npsnps]

Works a treat, thanks