MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA Code Protection

  Asked By: Zobah    Date: Nov 08    Category: MS Office    Views: 786

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

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

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

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?



3 Answers Found

Answer #1    Answered By: Betty White     Answered On: Nov 08

Yes. Turn on protection  in the VBE. It's a standard facility.

And perhaps do just a smidgen of research before asking questions that a
simple Google search will resolve in 5 seconds.

Answer #2    Answered By: Beverly Brooks     Answered On: Nov 08

It's standard functionality, but it's not immediately obvious.
You'd think that since Protection is under
Tools->Protection in Excel, that it would be found  there in VBA,
but instead it's under Tools->Macros, then select the Protection tab.

Answer #3    Answered By: Adelfrid Fischer     Answered On: Nov 08

Yes, thank you. Found it.......

Didn't find what you were looking for? Find more on VBA Code Protection Or get search suggestion and latest updates.