|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 30th, 2004, 06:45 AM
|
|||
|
|||
Custom Function & Personal.XLS
Excel 2000 SR1, Win2kPro
Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my Personal.XLS workbook it does get recognised, giving me a name error. My understanding is that Personal.xls modules, etc are availale to all open workbooks. Can someone help me to get this working. Thanks. 
|
|
#2
July 30th, 2004, 07:04 AM
|
|||
|
|||
|
Custom Function & Personal.XLS
Hi
you have to reference your workbook. so enter in a cell: =personal.xls!Formula_name() -----Original Message----- Excel 2000 SR1, Win2kPro Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my Personal.XLS workbook it does get recognised, giving me a name error. My understanding is that Personal.xls modules, etc are availale to all open workbooks. Can someone help me to get this working. Thanks. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom Markers | Jerez_z | General Discussion | 12 | June 14th, 2007 06:06 PM |
| Using a custom function in a query | BobRoyAce | Running & Setting Up Queries | 5 | May 27th, 2004 07:54 AM |
| Function not updating | Mark Hanford | Worksheet Functions | 10 | December 4th, 2003 02:42 PM |
| My own function cannot be exported. | Christian | Worksheet Functions | 0 | November 26th, 2003 03:22 PM |
Linear Mode
