I want to store a file containing macros on a shared drive on a network
I was told that if I saved the appropriate workbook file as an .xl
file, and then had each network user, in an .xls file, click-o
Tools>Add-Ins and activate the add-in, that the macros would b
accessible for such user.
It's not working out that way. Excel wants to store the add-in
folder under Documents and Settings, and under the username. Also
whichever workbook is first opened, even a blank Book1, the name o
that file is inserted before the path of the shared drive. Lastly, th
.xla is written to the shared drive as a hidden file.
My desire is to link individual macros to Custom Menu Buttons on th
Standard Toolbar for each user.
Can anyone help?
Chuckles12