Is There a Way To Create A Command Button, for example a Cancel Button that can take the programmer "in this case me" right to the code page even if the program is running. i am trying to create an administrator type password so that me or any one with a password can access the code.
UserForm Code
-
bugs63 -
February 9, 2020 at 5:48 PM -
Thread is marked as Resolved.
-
-
-
-
This works here with Excel 2007. It should work fine with you version.
The password portion of your project is not difficult to create. However, you are aware that it is pretty easy to open the
VBE, bypassing passwords ... yes ?
Please explain how you plan to protect the VBE .
-
Using the VBA Project Properties as a means to protect your source code will be sufficient for
end users who do not know anything about programming with VBA, do not have the DEVELOPER tab
active on their copy of EXCEL and are only basic users of EXCEL.
The password function built in to the VBA Project Properties is easily bypassed. You can verify this
for yourself by doing an internet search for bypassing or breaking the EXCEL password.
Not trying to talk you out of it ... just want you to be aware of the vulnerability of the builtin EXCEL
password system.
The next question is : Is there anything outside of EXCEL that can protect my code ?
The simple answer is : NO there is not.
There are plenty of 3rd party add-ons that claim to protect the code or obfuscate the code but those too
may be broken / bypassed.
Again .. just so you are aware.
-
If you protect the project then the code to access the VB Editor will fail.
Obfuscation is the best way in my opinion, it makes the code hard to decipher.
To protect the project Unviewable+ is probably the best, but it can be bypassed with the right software. There is also Doneex
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!