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
|
|||
|
|||
Custom Functions Available for all Workbooks
I have created some customized functions no the PERSONAL.XLSB file but I
cannot use them in any other workbook i use. I have plenty macros on this PERSONAL file and they all work well everywhere, but i dont see to find how to make the functions work in the same way. Is it possible to do this? Thank you. |
#2
|
|||
|
|||
Custom Functions Available for all Workbooks
click on the Fx symbol to the left of the formula bar. In the pop up use the
Category selector to choose User-defined. You'll find your functions there "Diego Miranda" wrote: I have created some customized functions no the PERSONAL.XLSB file but I cannot use them in any other workbook i use. I have plenty macros on this PERSONAL file and they all work well everywhere, but i dont see to find how to make the functions work in the same way. Is it possible to do this? Thank you. |
#3
|
|||
|
|||
Custom Functions Available for all Workbooks
You have to include the name of the file that contains the function...
=PERSONAL.XLSB!Your_Function_Here() -- Biff Microsoft Excel MVP "Diego Miranda" Diego wrote in message ... I have created some customized functions no the PERSONAL.XLSB file but I cannot use them in any other workbook i use. I have plenty macros on this PERSONAL file and they all work well everywhere, but i dont see to find how to make the functions work in the same way. Is it possible to do this? Thank you. |
Thread Tools | |
Display Modes | |
|
|