C
Cactus
I want make a VBA code module to be share module.
How I include a VBA module outside a workbook?
Thnkas.
How I include a VBA module outside a workbook?
Thnkas.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
OJ
Make it an Addin.
OJ
OJ
C
Cactus
OK.
I try save as xla., thx.
I try save as xla., thx.
C
Cactus
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.
D
Dave Peterson
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 worksheet menubar.
If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/[email protected]
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 worksheet menubar.
If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/[email protected]