add-ins

philR · Feb 26th, 2002, 04:53 AM

I have written some custom functions for excel in visual basic. They are currently stored in a module in my PERSONAL.XLS project. However there are a lot of people where I work who would like to use them. Is there any way to save the module as an add-in (on the network), so people can just use the Add-Ins on the Tools menu to install them?

Mudface · Feb 26th, 2002, 04:55 AM

Yes, just save your workbook as an add-in (from the save as type drop-down) and inform everyone of it's location. Then all they need to do is select Tools- Add-Ins and Browse to where your file is located and install it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 04:53 AM	#1
philR Board Regular Join Date: Feb 2002 Location: Sheffield, UK Posts: 249	I have written some custom functions for excel in visual basic. They are currently stored in a module in my PERSONAL.XLS project. However there are a lot of people where I work who would like to use them. Is there any way to save the module as an add-in (on the network), so people can just use the Add-Ins on the Tools menu to install them?

Feb 26th, 2002, 04:55 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Yes, just save your workbook as an add-in (from the save as type drop-down) and inform everyone of it's location. Then all they need to do is select Tools- Add-Ins and Browse to where your file is located and install it.