VBA security

[jay7gu]

Hi,

I am going to program in VBA for an application. Is VBA compliable? Can I hide the source code and give the user executable only?

Thanks,

[Leith Ross]

Hello jay7gu,

Welcome to the Forum!

If you are going to write a program in VBA, it will have to run in a program that supports VBA. Any of the Office suite programs: Access, Excel, Word, and PowerPoint support VBA. Some third party programs like AutoCad also support VBA. VBA doesn't provide a way to compile the source code into an executable. There are programs available for Excel that will compile the workbook and VBA macro into an executable, but I don't know about any other programs. You can hide the code by password protecting your project. This should be considered a safety measure against changing the code and not a method of securing the code. There is software available to break the VBA project passwords.

Sincerely,
Leith Ross