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: 2
Default Distributing macros with an addi-in

Please lend a hand to someone who has written a fair number of macros for
Word and is now trying to understand the world of Excel.

The macro in question is simple and runs fine.

I've put it in an ad-in with a custom toolbar with the macro on it, and
written a Workbook_AddinInstall() routine in the ThisWorkBook object that
adds a menu item for the macro; also a Workbook_AddinUninstall() that
deletes it.

These macros also behave as expected when run manually from within the vba
editor.

But here is what happens when I install the add-in on another computer and
then add it using the tools add-ins.

1) The macro is not available using tools macros.

2) The Workbook_AddinInstall() macro does not run and the menu item is not
added

3) The toolbar is available, but the button no longer runs the macro.

If I open the add-in from within Excel, I can then reassign the macro to the
button on the toolbar and then it will run--for as long as the add-in is
open (not just added in, but actually open using File Open).

I'm going to skip the code because the code seems to run fine. The problem
is in how I am going about things. Can someone please tell me what the right
way is? (If there is a decent explanation on the web, a link would suffice
and be much appreciated.)

Thank you very much.


 
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
Distributing a UDF David Excel Programming 3 November 30th 05 11:56 AM
Please let me know from where I can download Analysis Toolpak Addi Hari Kalakada Setting up and Configuration of Excel 3 August 24th 05 06:35 AM
distributing add-ins lee hite Excel Programming 6 October 14th 03 09:11 PM
Distributing Macros Carm Excel Programming 1 September 2nd 03 06:05 AM
preserving type library references when distributing macros gene Excel Programming 0 July 11th 03 02:43 PM


All times are GMT +1. The time now is 05:26 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"