Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Charles, Thank you! Why do you recommend not to store .xla files in the Microsoft AddIns folder? Thanks for the recommendation about the AddIn Loader software; I will check with our network people. I have had some success with Custom Buttons accessing the macros stored in an .XLS file on our shared drive (I know this because, when the macro security window (Disable - Enable choice) pops up, it displays the path of the macro source. Curiously, when clicking-on ToolsAddIns, there is a check-mark next to the appropriate addin, and then, when clicking on Browse, the path is to the addin stored in the Microsoft AddIns folder on my C drive. This latter situation is due to 2 lines of code I keyed in at the top of the primary macro (essentially, it places a check-mark next to the appropriate addin on the ToolsAddIns menu). <<== weird combination, but it works. The next test is to see if it works for other users on our network. When I find out, I will post this thread. Regards, Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=267013 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sharing Macros | Excel Worksheet Functions | |||
sharing macros | Excel Discussion (Misc queries) | |||
Sharing Macros | Excel Discussion (Misc queries) | |||
sharing macros | Excel Discussion (Misc queries) | |||
SHARING MACROS VIA ADD-IN (.xla) FILE | Excel Programming |