Deploying an Excel Application

[triaz]

I have created an excel application to perform a specific set of tasks.
This application has a custom menu, templates and macros. Is there a
way I can package this so that other users can use it without me having
to set up menus, associating the macros and placing templates in the
right locations each time a user requests this tool be installed on
their systems ie can I some how create a deployment package that could
do this?

Thanks in advance

T.

 

[Guest]

I do this by creating an add-in.
An add-in is just another wbk that is invisible.
The add-in has code to create and display a new custom menu.
It then opens the GUI - the wbk that the user sees and interacts with.
The code behind the menu items is contained in the add-in and is password
protected (from the casual user).

I then deploy all of the above plus desktop icon etc by using
VB Suite 6.0 to create an installation wizard.
I have actually created an installation wizard totally in excel vba
but it's not as smooth as the VB 6.0

If the above is unfamiliar to you and you want some reference material, I
suggest you invest $50 plus some time to study Stephen Bullen's
Professional Excel Development

Hope this helps