witamserdecznie
New Member
- Joined
- Jun 12, 2010
- Messages
- 34
Hi,
I have seen that in one spreadsheet a worksheet password in VBA looked like: Const password = "é]CÔŢ~áü$đŚ¸»łË=‚XTŁµĂš`;픟‘¨ěۆČFFĚö4żą0"
And yet when it came to: ThisWorkbook.ActiveSheet.UnProtect Password:=password it worked perfectly fine.
However when I type in this password in the review -> unprotect sheet then it does not work.
How to make a password show in VBA in an encrypted way as shown above? Say in the VBA it looks like "é]CÔŢ~áü$đŚ¸" but in the unprotect popup window you type in "secretpassword" and the sheet is unlocked?
Thanks.
I have seen that in one spreadsheet a worksheet password in VBA looked like: Const password = "é]CÔŢ~áü$đŚ¸»łË=‚XTŁµĂš`;픟‘¨ěۆČFFĚö4żą0"
And yet when it came to: ThisWorkbook.ActiveSheet.UnProtect Password:=password it worked perfectly fine.
However when I type in this password in the review -> unprotect sheet then it does not work.
How to make a password show in VBA in an encrypted way as shown above? Say in the VBA it looks like "é]CÔŢ~áü$đŚ¸" but in the unprotect popup window you type in "secretpassword" and the sheet is unlocked?
Thanks.