VBA Compiler Help


#1

I am completely new to VBA and do not understand the instructions for the VBA compiler.

I do not have any VBA on any of my worksheets, but I do have lots of recorded macros in different modules.

To compile these, do I CUT them from their original module and paste them into the compiler, or do I leave them in their original module and COPY them into the compiler?

I’m sure this is a dumb question, but I’m completely lost on this part of the process. I copied and pasted all of my macros into a Word doc just to make copying and pasting easier and I have 59 pages of macros!

Thanks in advance.


#2

You don’t have necessarily to move your entire VBA project to the VBA compiler. Only some parts that have to be vital to your app should be moved. The goal is that if someone was able to break our protection, the code would not be there, because the VBA compiler turns VBA code into bytecode executed by the secure app and not Excel.