C Cactus Jun 16, 2005 #1 I want make a VBA code module to be share module. How I include a VBA module outside a workbook? Thnkas.
I want make a VBA code module to be share module. How I include a VBA module outside a workbook? Thnkas.
C Cactus Jun 16, 2005 #4 Make it an Addin. Click to expand... Saved a .xls as .xla, and set it into Addin list. functions are list in sheets. but still can't calling in VBA code.
Make it an Addin. Click to expand... 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 Jun 16, 2005 #5 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]
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]
