I have a Excel VBA program that I need to distribute to my customers, Is it possible to save the VBA portion of a worksheet and allow others to load it into an existing work sheet?
Thanks,
Bob
I have a Excel VBA program that I need to distribute to my customers, Is it possible to save the VBA portion of a worksheet and allow others to load it into an existing work sheet?
Thanks,
Bob
Hi Bob,
If you're just wanting to send the small text file that contains the VBA code then just go into the VB environment with Alt-F11, find the module that contains the code and from the VB menu choose File, Export file and save it in the usual way.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
In the alternative, you could ceate an add-in and email that to them. They'd stick it in a directory and then install it in the usual fashion.
If that path interests you, see http://www.fontstuff.com/vba/vbatut03.htm
Entia non sunt multiplicanda sine necessitate
The problem is, I need this to be a password protected Macro or a protected addin
You can protect the VBA project in an add-in, just as in any other workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks