share excel macros
 

I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations for
files located on the network?

share excel macros
 

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations
for
files located on the network?

share excel macros
 

How do I create an add-in for this purpose?


"Bob Phillips" wrote:

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations
for
files located on the network?

share excel macros
 

Essentially, all you do is put all your code in a new workbook, and then do
a SaveAs with a file type of xla (at the foot of the list). The xla file is
then installed (ToolsAdd-InsBrowse and find it).

--
HTH

Bob Phillips

"Glen" wrote in message
...
How do I create an add-in for this purpose?


"Bob Phillips" wrote:

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How
can I
copy or have my macros available for others to use at their
workstations
for
files located on the network?