xla files

[Marcelo Rychter]

Can I use general procedures in xla files, beyond only functions? I would like to use xla files to store many procedures that are not functions (sub <name>).

If positive, how do I invoke a procedure that resides in a xla file?

Thanks in advance,
Marcelo Rychter

[rylo]

Hi

1) yes you can.

2) Say you have a sub in module1 in your addin.

sub bbb()
msgbox "fred"
end sub

The addin has been enabled in you tools, addin area.

In a general module in an open workbook, enter the code.

sub aaa()
application.run "module1!bbb"
end sub

Run the code and the message fred should appear.

If you want to, create a toolbar icon and attach the macro to that button.


HTH

rylo