#1
|
|||
|
|||
Excel 2003 User Defined Function
Hi All, I'm trying to make some user defined functions available to any user who opens my workbook on any computer. I've saved the original workbook in which the UDFs were created as an excel add-in. In my new workbook (the one I want to distribute to others), I've activated that add-in and can now enter the UDFs into any cell in the new workbook without having to type the name of the original source. So it works perfectly, but only on my computer. The problem I'm having is that whenever I e-mail this new spreadsheet to anyone else and they open it on their own computer, the UDFs don't work: the formulas in the cells suddenly contain the original source file name and a "#name" error appears there. Furthermore, the add-in is no longer available and they don't see my UDFs in the Visual Basic Editor page. I'm at best an intermediate-level excel user, so it's probably something very basic that I'm missing here. Does anyone have any ideas how to fix this? Also, I'm not sure if this is a factor or not, but both my original excel workbook in which the UDFs were created and the new workbook that I'd like to distribute were created and currently reside on my Windows Server 2003 desktop, not on any physical hard drive. |
#2
|
|||
|
|||
Those UDF's shoud be in a VBA module in that workbook's VBA project, to work on any computer that opens that workbook . UDF from an add-in works only for your computer. Another way is that you send them the add-in to be installed on those computers.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FileSystemObject Compile Error: User-Defined Type Not Defined | gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
Sub or Function not defined error - GetParaIndex Word 2010 | jec1 | Word VBA | 1 | 05-24-2012 11:58 PM |
Edit Multiple Emails' User-Defined Field | ryancaseymcshane | Outlook | 0 | 10-04-2011 07:40 AM |
Compile error: sub or function not defined.. | xena2305 | Excel Programming | 0 | 08-02-2011 10:17 AM |
User Defined Default Settings in Insert | J_oe | Word | 1 | 02-17-2011 10:55 AM |