Private Function StrToPsd(ByVal Txt As String) As Long So you need to decrypt that saved password and match it with your inputted password by user.īelow is an example of Encryption and decryption code. You can save this password in hidden worksheet and Encrypt this password so if anyone make the hidden sheet visible then also they don't get the real password. you will check for another password, that is asked by your developed code. So what I think to solve the issue is, after VBA code get unlocked (Whether by Authenticated or Unauthenticated user). so at that time code will also be deleted. So you had mentioned that when hidden worksheet get Activate you want to delete the all VBA code from the project.īut it can also Activate when some Authenticated user access the hidden worksheet. We can't fetch and match what they inputted is correct or not. You had mentioned that you want to delete all the code if password is break.īut actually they are not inputting the password and there is no way to check whether they input the correct password to unlock the VBA code or not because we don't have any control on that. I find that in that code, it generates the keys that you can enter as password to unlock the VBA code. I try to search regarding the VBA code that can break the VBA project password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |