Chekcing your own code???

[Kryzsoccer]

Is there a way to have VBA check it's own code(i.e. maybe compare it to a textfile).
I want it to make sure that no one can alter my code in any way.
Thanks in advance!

 

[RobBroekhuis]

And using the VBA protection features isn't sufficient? They are your first line of defense.
Rob

 

[Kryzsoccer]

What are the VBA protection features and how do you use them?
(By the way, I am using VBA with Microsoft Word)

 

[Kryzsoccer]

STUPID, STUPID! Shame on me for posting without first searching the forum! This protection should be perfect, THANKS, Rob, for pointing me in the right direction!

 

[rmikesmith]

Kryzsoccer,

What you asked could be done, but Rob's suggestion is the way to go. Anyone knowing enough to change your code would be able to circumvent the VBA self-inspection. Too much work for too little payoff.

Regards,
Mike

 

[chogben]

Have a look at digital certificates. It will prove that the vba code was written by you, AND hasn't been altered by anyone else.

Of course, if you don't want people to look at your code, then just protect it. If you don't think sticking a password is enough (I'm sure there are ways around), then consider creating a .dll (in visual basic) to hide as much code away as possible.