Unanswered: Excel function or sub routines available to all excel present and furture
Win 2k and XP
I want to write either a module or excel sheet sub routines or functions and make those available to all the excel application present past and future just as objects are available in the excel vb library. How do I do that???
You can put all the routines you want in a single Excel file and save it as an add-in, then install the add-in.
This will make all the functions and routines in the add-in available to your current worksheet. However only on the machine that contains the add-in. If you use the file on another machine any functions used will be unavailable.