Password Protect Workbook via code

  • Thread starter Thread starter John Wilson
  • Start date Start date
J

John Wilson

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
 
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
 
Back
Top