Password Protect Workbook via code
 

Couldn't seem to find this in Google.
Hopefully, it's possible.....

Scenario:
Macros are enabled
Someone other than an authorized user has opened the workbook.
One critical sheet of the workbook is copied to a newly created workbook

(all of the above I can accomplish)
I want to save that newly created workbook with a "Password to Open"
I'll then close that workbook and delete the original one completely.

Understood that it's futile to attempt this but for my particular
audience
it should work.

Thanks,
John

Password Protect Workbook via code
 

Couldn't seem to find this in Google.
I guess I didn't search hard enough the first time.
Found what I was looking for.
Thanks Dave.

John

John Wilson wrote:

Couldn't seem to find this in Google.
Hopefully, it's possible.....

Scenario:
Macros are enabled
Someone other than an authorized user has opened the workbook.
One critical sheet of the workbook is copied to a newly created workbook

(all of the above I can accomplish)
I want to save that newly created workbook with a "Password to Open"
I'll then close that workbook and delete the original one completely.

Understood that it's futile to attempt this but for my particular
audience
it should work.

Thanks,
John