Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing function in a module
Hi;
I have a user that has a function he has written to calculate tax rates. The function is stored in a module in a spreadsheet. What is the best way to share this function with all of his spreadsheets? Is there a way to make this module available to all open worksheets? Your help is greatly appreciated! Julie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing function in a module
Put the code in a new workbook. Make the new workbook an addin
Load the addin (tools=Addins, browse button) -- Regards, Tom Ogilvy "Julie" wrote in message ... Hi; I have a user that has a function he has written to calculate tax rates. The function is stored in a module in a spreadsheet. What is the best way to share this function with all of his spreadsheets? Is there a way to make this module available to all open worksheets? Your help is greatly appreciated! Julie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing function in a module
Thank you Tom!
-----Original Message----- Put the code in a new workbook. Make the new workbook an addin Load the addin (tools=Addins, browse button) -- Regards, Tom Ogilvy "Julie" wrote in message ... Hi; I have a user that has a function he has written to calculate tax rates. The function is stored in a module in a spreadsheet. What is the best way to share this function with all of his spreadsheets? Is there a way to make this module available to all open worksheets? Your help is greatly appreciated! Julie . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Call Private Function from ThisWorkbook module | Excel Programming | |||
Calling VBA function that is in another module | Excel Programming | |||
Calling a module function from a class method | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |