How to vba code?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sjw - 15 Sep 2006 22:47 GMT

In MS Access I can hide my code by converting from a .mdb to a .mde

Is there something similar in Word to prevent users from accessing the code?

Reply to this Message

Jay Freedman - 16 Sep 2006 02:01 GMT

In the VBA editor, go to Tools > Project Properties > Protection.
Check the "Lock project for viewing" box and supply a password.

This won't stop a determined attack, but it will prevent casual
snooping and inadvertent changes.

If you need something more secure than that, write your code in VB6
and compile it to a DLL. Then in VBA write a macro that just calls the
DLL.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

>In MS Access I can hide my code by converting from a .mdb to a .mde
>
>Is there something similar in Word to prevent users from accessing the code?

Reply to this Message

sjw - 16 Sep 2006 02:32 GMT

PERFECT!

Thanks Jay

> In the VBA editor, go to Tools > Project Properties > Protection.
> Check the "Lock project for viewing" box and supply a password.
[quoted text clipped - 16 lines]
> >
> >Is there something similar in Word to prevent users from accessing the code?

Reply to this Message