Security for VBA codes
 

I haven't notice any on this subject. So...
Is there a way to PW protect the VBA screen? Also, assuming there is,
can it be set up to allow others to edit (and save) the spreadsheet
only? I poked around the pull down menus, but couldn't see an
explaination. It must be so simple that I just didn't see it.
As always..... I would appreciate any help.
excelnut

Security for VBA codes
 

From the VB Editor, go to Tools VBA Project Properties and select the
Protection tab. There you have the option to set a password for the project.

"excelnut1954" wrote:

I haven't notice any on this subject. So...
Is there a way to PW protect the VBA screen? Also, assuming there is,
can it be set up to allow others to edit (and save) the spreadsheet
only? I poked around the pull down menus, but couldn't see an
explaination. It must be so simple that I just didn't see it.
As always..... I would appreciate any help.
excelnut

Security for VBA codes
 

Thanks! I was in that screen before. But, I just didn't test it right.
Too busy that day.
Brain cramp.
Thanks again.

Security for VBA codes
 

I'm glad that I found this section. I had the exact same question. However,
now that that one is answered I have another. I found that if you copy the
sheet to a new workbook the protection does not stay.

I'm not worried about a user changing my code, I don't want them to see the
code at all, under any circumstances.

Is this possible?

The only way I can think of doing this is by protecting the code and
disabling sheet moving/copying. (Don't even know how to do that though)

Any help is much appreciated.

Mike

"bpeltzer" wrote:

From the VB Editor, go to Tools VBA Project Properties and select the
Protection tab. There you have the option to set a password for the project.

"excelnut1954" wrote:

I haven't notice any on this subject. So...
Is there a way to PW protect the VBA screen? Also, assuming there is,
can it be set up to allow others to edit (and save) the spreadsheet
only? I poked around the pull down menus, but couldn't see an
explaination. It must be so simple that I just didn't see it.
As always..... I would appreciate any help.
excelnut

Security for VBA codes
 

If your code does a lot of complex stuff, obfuscating it (replacing it
with functionally equivalant, but much harder to understand code) will
make it harder for anyone who gets at it to understand what you are
doing, and that may be adequate.

A free, open source, Excel/VBA source code obfuscation Add-in is
available at:

http://invisiblebasic.sourceforge.net/

John