I want to add a function in MS Office. Currently I'm looking to develop in VBA. However, it seems that the execution of macros requires security disabled. This means that when I distribute the VBA program, others have to enable macros to run. (Security Issues) The problem now is how do I distribute the VBA I wrote ZB in an EXE And there is another way to go about creating this module?
Dear Grover L Pyne
The simple answer of your question is via add ins. Add ins are used to distribute "Macros".
Add ins creation to distribute Macros:
Now follow the steps below to create and distribute add ins. Add ins are simply Excel workbook (we are taking here excel is an example) which are save with xla extension. To do this simply create a work book and save as and choose "xla" as extension. Once created,  workbook can only be viewed in "Project Explorer" via "Visual Basic Editor".
Add ins Distribution:
After following the procedure below other users can easily open / install your add ins .
Â
Â
Â
