Hi all,
I have read a lot of comments that the best way to protect our Excel add-in VBA code is to use Visual Basic 6.
I wish to know what is the process to convert the xla file with VB6. Initially, I thought it was just an easy process of opening the xla file in VB6 and a few mouse clicks. Apparently, it is more than that.
I have made a search on goggle (see webpage below) but could not understand the contents as it is too technical for me.
http://www.cpearson.com/excel/AutomationAddins.htm
In addition, it seems like the way to call a procedure (after VB6 has "hide" the VBA code) is entirely different. I am quite confused. Could someone give me some pointers?
Regards.