password protect code and custom field formulas

[Lucas Soler]

How can I protect module code from being viewed? Custome fields too?

 

[Rod Gill]

Hi,

In Visual Basic Editor select Tools, VBAProject Properties
In the Protection column you can password protect.

You can't protect formulae unless you are using Project Server.

However, by renaming custom fields under Tools, Customize, Fields you can
make it clearer what a field is used for so it isn't used for two things by
mistake.

 

[JackD]

Here is how to protect a module:
http://zo-d.com/blog/archives/programming/securing-your-ms-project-files-and-macro-code.html
You can't keep customfield formulas from being viewed.
What is the reasoning for hiding the formulas?

 

[Lucas Soler]

There are some funky formulas that I want to make sure aren't changed, and
aren't viewed, in order to protect my work.
C/S Solutions, the makers of wInsight, introduce some custom fields into MSP
that aren't visible. I'd like to do the same thing.

 

[JackD]

If they aren't visible how do you know that they are there?
If you can see the field, then you can see the formula in the field.
The only way that you won't be able to see the formula is if the formula is
not in the field but is a VBA macro.
If you want security, then VBA is the way to go, but remember, even if you
"protect" your code, breaking the protection is trivial with a little
research.