VBA Security

[Dave]

Hi

Is it possible to secure the VBA in an excel project, so that it cannot be
openned, even with third party software, such as that from Elcomsoft? I know
how to password protect the VBA, using the project properties, but have
heard that there is software that can either crack this password, or use a
"backdoor" to gain access to the source code. Is there anything that can be
done to prevent uch software allowing access to the source code?

Many thanks in advance for help,

Dave

 

[Tom Ogilvy]

move most of the code or critical parts of the code out of excel and compile
it (would probably require extensive rewrites) . Within Excel, no.