I will admit firstly that I have not looked beyond the menus to
determine if this is possible. My apologies if this is a very simple
problem.
I have some VBA code the fills in an excel spreadsheet that will be
used by more than a few people in my office. I do not want this form
to be modified in any way without my permission. I have found a good
way to protect the sheets within the workbook while still allowing
the use of the form to edit the protected cells; however, the code
can still be viewed (where the password is kept for
protect/unprotect of sheets) and modified to even eliminate the
protection.
Is there a way to protect the code from modification, and is there a
way to require a password to even open the VB editor to view the
code?
I know hackers would find a way around it without too much trouble,
but I just need some basic coutermeasures, not hacker-proof code.
Any thoughts?