If you work in a networked environment, you may have a need to make a common set of custom functions available to all the users on your network. For instance, your company may have some specialized functions that perform some financial calculations in a particular way. You may be wondering how to best supply these functions to users on your network, without allowing them to modify the functions themselves.
Perhaps the best way to handle this situation is to put all your functions into a single worksheet, and then compile the worksheet into an Excel add-in. You can then place the add-in on a shared network directory from which everyone can access the add-in. If you need to change the functions in the future, simply update the add-in and copy it to the shared directory. The next time a user starts Excel, the newly updated add-in is loaded, and the updated functions are automatically available.
Information on how to create add-ins is available in other issues of ExcelTips or on the ExcelTips website. You can also find some information in the Excel help files.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2346) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Making Common Functions Available to Others.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Need a quick way to change the default drive and directory in a macro you are writing? Here's the commands to do it and a ...
Discover MoreAdd a graphic to a worksheet as part of an Image object, and you can use some very handy event handlers to figure out the ...
Discover MoreVariable arrays are used quite often in macros. If you use an array once in your macro and then need to reuse it for ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments