prionus
asked on
VB Subroutine to Excel Add-In
I have a number of useful Visual Basic subroutines and functions which I'd like to make available to the Excel users in my office (all are non-VB or VBA users). I know these could be added as VBA subroutines and functions; however, I'd like to protect the security of my source code. I'd like to create Excel Add-In modules based upon my VB subroutines or functions. Are there useful books or web sites where I can get more information on the mechanics of building Excel Add-In, especially for a VB programer. Thanks in advance for your assistance.
I goofed.
I the code editor, set a password for viewing in the properties dialog box.
I the code editor, set a password for viewing in the properties dialog box.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've build some Add-Ins myself. The most important sections are:
Private Sub Workbook_AddinInstall()
End Sub
Private Sub Workbook_AddinUninstall()
End Sub
These are for loading and unloading the Add-In.
You can place up to anything in here. Add menu's, calls to functions and so on.
In the above example a new item is created in the menu.
Just can also do this and refer to your own functions.
D'Mzzl!
RoverM
Private Sub Workbook_AddinInstall()
End Sub
Private Sub Workbook_AddinUninstall()
End Sub
These are for loading and unloading the Add-In.
You can place up to anything in here. Add menu's, calls to functions and so on.
In the above example a new item is created in the menu.
Just can also do this and refer to your own functions.
D'Mzzl!
RoverM
Hearing...
Richie: You've got some kind of text2speech converter for EE ? <LOL>
ASKER
Thanks to roverm for plenty to work with. I also want to thank triskelion for their suggestion.
Sorry, roverm but no.
Anyway, there is some examples on net regarding it.
Maybe in HD, let me see...
By the way, congratulations for this one ;)
Anyway, there is some examples on net regarding it.
Maybe in HD, let me see...
By the way, congratulations for this one ;)
Richie: I was just kidding for you comment "hearing..." Thanks anyway! :>>
Prionus:
Thanks for the points!
D'Mzzl!
RoverM
Prionus:
Thanks for the points!
D'Mzzl!
RoverM
Gee...
Richie:
I downloaded the example from planet-source-code.
Just one word: WOW!!!!!!!
This is a great OCX. Thanks!
D'Mzzl!
RoverM
I downloaded the example from planet-source-code.
Just one word: WOW!!!!!!!
This is a great OCX. Thanks!
D'Mzzl!
RoverM
Change the type to Add-in,
use a modify password and you're done.