LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default SHARING MACROS VIA ADD-IN (.xla) FILE


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing Macros enna49 Excel Worksheet Functions 1 February 19th 10 01:03 PM
sharing macros Whitney Excel Discussion (Misc queries) 3 June 28th 08 09:47 AM
Sharing Macros Russ Excel Discussion (Misc queries) 2 August 9th 05 02:58 AM
sharing macros fabulousk Excel Discussion (Misc queries) 3 March 7th 05 10:05 PM
SHARING MACROS VIA ADD-IN (.xla) FILE Chuckles123[_20_] Excel Programming 1 October 6th 04 11:14 PM


All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"