Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Non Standard Function in EXCEL 1
- Thread starter vladk
- Start date
-
1
- #2
1. Write the function in a module in VBA (Make sure it is Public).
2. Save the excel file as an addin in your office\Library directory.
3. Go to Tools-Addins in excel and add your file. This function will then be available in every workbook you start or open.
You can place as many functions in the module as you like. so they will all be available by adding just one addin.
2. Save the excel file as an addin in your office\Library directory.
3. Go to Tools-Addins in excel and add your file. This function will then be available in every workbook you start or open.
You can place as many functions in the module as you like. so they will all be available by adding just one addin.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Solved
- Locked
- Question