#1
|
|||
|
|||
Function not available from personal.xlsb
Hi there
when I create a public function and define it in a module within a spreadsheet.xlsm I can access it as a formula from within that spreadsheet. However if I move that same function to the personal.xlsb spreadsheet then it is no longer accessible. I have many macros defined in personal.xlsb which are available to me from any spreadsheet I open. How can i make functions defined in persnal.xlsb available to any spreadsheet I open? Many thanks for any reply |
#2
|
||||
|
||||
You need to prefix the function call with the workbook name:
=Personal.xlsb!function_name() |
Tags |
function personal missing |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
Error message opening xlsb file in Excel 2008 for Mac | Bryce | Excel | 1 | 07-27-2014 09:35 AM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
Visibility of macros in PERSONAL.XLSB | Dougiel | Excel | 0 | 05-24-2012 12:32 AM |