How to call module function or sub from the Add In?

  • Thread starter Thread starter Archidamos
  • Start date Start date
A

Archidamos

Hi all,
I have an Add In which is used by many worksheets.
In every worksheet module there is the starting sub 'Start'.
I created the icon in the Quick Access Toolbar and connected it to the macro located in Add In. From this macro I want to run the sub Start, which is in module belonging to currently opened worksheet.
In summary, the point is to use one icon to run the macro 'Start' in different worksheets.
But it's not working. Excel says 'Sub of Function not defined'.
It's there any way to run module macro from an Add In?
Thanks in advance.

Archidamos
 
Hi,

Am Fri, 21 Feb 2014 06:35:40 -0800 (PST) schrieb Archidamos:
I have an Add In which is used by many worksheets.
In every worksheet module there is the starting sub 'Start'.
I created the icon in the Quick Access Toolbar and connected it to the macro located in Add In. From this macro I want to run the sub Start, which is in module belonging to currently opened worksheet.
In summary, the point is to use one icon to run the macro 'Start' in different worksheets.
Click to expand...

if you run a macro from a different workbook you have to write the
workbook name and the macro name like this:
Application.Run ("'" & ActiveWorkbook.Name & "'!Start")


Regards
Claus B.
 
W dniu pi±tek, 21 lutego 2014 15:59:04 UTC+1 u¿ytkownik Claus Busch napisa³:
Application.Run ("'" & ActiveWorkbook.Name & "'!Start")
Click to expand...

Thank you very much Claus!

Regards
Archidamos
 
Typically, addins create their own menus/toolbars at startup and remove
them at shutdown. This is particularly the case when the addin's
procedures are to be used with other workbooks.

In early versions of Excel addin menus are placed on the default
menubars and/or use their own toolbar. In 2007 and later these will
appear on the 'Addins' tab of the Ribbon.

So there's no need to use the QAT, and there's never a question as to
whether the macros associated with custom menus are available since
they're created when the addin opens and removed before it closes.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top