David_Welland
New Member
- Joined
- Jul 16, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have built a tool for people to use with a macro to export a number of customer facing sheets.
I’d like to password protect the macro but rather than a generic password built into the macro I’d like to link it to the text in a cell.
For instance:
People use the tool
Send it for approval
An approval reference code is given
That approval reference is then the password to unlock the macro
I would like to give other areas of the business the ability to provide a reference code so don’t want it in built into the VBA
I’d like to password protect the macro but rather than a generic password built into the macro I’d like to link it to the text in a cell.
For instance:
People use the tool
Send it for approval
An approval reference code is given
That approval reference is then the password to unlock the macro
I would like to give other areas of the business the ability to provide a reference code so don’t want it in built into the VBA