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

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

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


.