View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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?