Re: Can I share a VBA module for multi-workbooks.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Since you installed the addin, you can use the userdefined functions just like
builtin functions:

=myFunct(A1,a2,a3)
(say)

But you have to give the user some way to run your subroutines.

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the work*** menubar.

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/groups?threadm=40E095F1.5CB35B41%40msn.com

Cactus wrote:
>
> > Make it an Addin.
> >
>
> Saved a .xls as .xla, and set it into Addin list.
> functions are list in sheets.
> but still can't calling in VBA code.

--

Dave Peterson
.

Quantcast