Matt, if a file is an add-in, the macros are not visible by design. The
solution is to either create a commandbar and assign the macros to buttons
on it, or to add a new menu and menu items to the Excel worksheet menu. My
recommendation is the second. It is easier. And, when you close Excel,
have Excel delete the menu you added.

Have the users keep the add-in in a particular directory, say program
files\MyAdd-ins. And load it as an add-in via Tools, Add-ins. The name
that appears on the add-in list is the title property of the workbook. You
may have to convert to a workbook, set the title, then convert back (IsAddin
is a workbook property you can change).

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"matt4003 " wrote in message
...
I am having the same problem after creating the Add-in....the macro
isn't available.

Also, I am trying to maintain 7 different files which all use the same
macro to formate the input and layout of the data. As we continue to
develop our biz processes I am going to need to update the macro that
controls these files. All the files are in the same shared directory.
It justs takes too long to open every file, manually update the macro
and save everything, files located on a network drive in Germany, takes
a while to save.....any thoughts on how I could distribute the code to
these files??


---
Message posted from http://www.ExcelForum.com/