Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Trouble with Sharing Addins

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SLW612 - 26 Sep 2007 16:50 GMT
I have a macro that I want to share with other users on my network. I went
through all of the steps to create an addin and it works fine on my system,
opens with every workbook, etc. but I can't figure out how to get it to work
on someone else's machine.

I emailed him the addin file and saved it to the same folder on his machine
that it was on mine (c:\documents and settings\...\application
data\microsoft\addins) and when I opened up his Excel I went to tools,
addins, browsed to find this file, and checked the box next to it.

But when I try to run a macro, it says none are installed. The addin
contains one macro, but it's not showing up on his computer ... ?  What am I
not doing right?
M. Authement - 26 Sep 2007 19:42 GMT
You cannot access an add-in's macros through Tools\Macros.  You will need to
create a toolbar or menu, or maybe you could create a keyboard shortcut in
the add-in's AutoOpen procedure.

>I have a macro that I want to share with other users on my network. I went
> through all of the steps to create an addin and it works fine on my
[quoted text clipped - 13 lines]
> I
> not doing right?
Randy  Harmelink - 26 Sep 2007 21:21 GMT
> You cannot access an add-in's macros through Tools\Macros.

Not true.  The dialog just doesn't list the macros that exist in the
add-ins being used.  But you can still type in the name of an add-in
macro and run it (or assign a shortcut key to it).

In addition to your suggestion of creating a toolbar or menu entry,
they can also be assigned to objects in the workbook.  I often have
set up a cell so that clicking on the cell runs an add-in macro.
M. Authement - 27 Sep 2007 20:48 GMT
Thank you for that clarification...I did not know that!

>> You cannot access an add-in's macros through Tools\Macros.
>
[quoted text clipped - 5 lines]
> they can also be assigned to objects in the workbook.  I often have
> set up a cell so that clicking on the cell runs an add-in macro.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.