Hi
How can I protect VBA code from changing and even viewing by poeple who work with the Word document.
Thanks

Hi

You can do that as follows

From Tools menu of VBE select the Project's properties

VBE-->Tools-->Properties

Click the protection tab

Check the 'Lock project for viewing' dialog

Set the password for viewing in the text boxes

Save the project

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi
Sorry for being late.
How reliable this method is? what's the probablity that this lock is broken?
and another question:
I've heard about a tool that make the code unreadable. for example it change the variable name 'Title' to 'HVKBmasc_sadc_vsac_sdac' or something longer that cannot be read. what are the name of these tools and how much do you know about them?
Thanks

Hi

If you are really concerned about the code safety, then you can try for some compiled solutions. VBA code even though protected can be easily broken by external tools.

Try for creating some DLLs that are really safe and then you can use them in your VBA

All you will be doing is write the business logic in class library project adn compile them as a DLLs then use it in VBA project

Regards
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi
1- Adding dll file is done this way? Tools->References->Browse
2- Is dll file embeded in doc file?
3- How can I compile a VBA file to dll file? I don't have VB 6 installed on my machine.
Thanks

Hi

You have to create DLLs in Visual Basic and then you can include the DLLs in tools --> references

You can also try creating a solution using VSTO (which is .NET based)

Also have a look at http://msdn.microsoft.com/en-us/libr...ffice.10).aspx if this gives any help

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)