| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PERSONAL.XLS won't take custom functions
=personal.xls!MyFunction(a1,b1,c1)
If you save your personal.xls workbook as an addin, then you don't need this "prefixing" stuff. But you won't see macros in that .xla (or any .xla) in the Tools|macro|macros dialog. OxMan wrote: I am developing some custom funtions that I want to use in all my workbooks. When I put the code in a module for an individual workbook it works fine. When I put the code in PERSONAL.XLS it does not work. I try to use the formula and I get a #NAME error. Any suggestions how I get this thing working? -- OxMan ------------------------------------------------------------------------ OxMan's Profile: http://www.excelforum.com/member.php...o&userid=26392 View this thread: http://www.excelforum.com/showthread...hreadid=396727 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Functions in Personal.XLS | Excel Programming | |||
| Custom button on custom toolbar wants to re-load "Personal.xls" | Excel Programming | |||
| Custom Function on Personal.xls | Excel Programming | |||
| Using functions in personal.xls | Excel Programming | |||
| Custom Menus in Personal.xls | Excel Programming | |||
Threaded Mode
