I have a bank of user defined functions (UDF's) which I keep in the personal.xlsb workbook.
I used to run Excel 2003, and the same functions worked fine both in the personal.xlsb and main worksheets.
In Excel 2010 I can use them in the personal.xlsb workbook when it is unhidden, but cannot do so in any other workbook when personal.xlsb is hidden.
My Trust Centre settings allow the use macros at all times. There are no disabled items in the add ins and both the Roaming (User Start Up) and the Program Files (Excel Start) XLSTART folders are in the list of trusted locations.
I have googled around this and not found a solution! Can anyone help me please.
Possibly upgrading to 2013, does anyone know whether this problem manifests itself there?!
Thanks
I used to run Excel 2003, and the same functions worked fine both in the personal.xlsb and main worksheets.
In Excel 2010 I can use them in the personal.xlsb workbook when it is unhidden, but cannot do so in any other workbook when personal.xlsb is hidden.
My Trust Centre settings allow the use macros at all times. There are no disabled items in the add ins and both the Roaming (User Start Up) and the Program Files (Excel Start) XLSTART folders are in the list of trusted locations.
I have googled around this and not found a solution! Can anyone help me please.
Possibly upgrading to 2013, does anyone know whether this problem manifests itself there?!

Thanks