kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hi,
I want to use vba to dynamically password protect my workbook.
I have a table that contains the list of passwords that I want to use.
I want a code that will password protect the workbook using one of the password from the list.
Then when I want to unprotect the workbook, if the entered password can be found among the list, then unprotect the workbook.
If the above is possible, can someone some me how?
Thanks in advance.
Kelly
I want to use vba to dynamically password protect my workbook.
I have a table that contains the list of passwords that I want to use.
I want a code that will password protect the workbook using one of the password from the list.
Then when I want to unprotect the workbook, if the entered password can be found among the list, then unprotect the workbook.
If the above is possible, can someone some me how?
Thanks in advance.
Kelly