Enable a user defined formula in all excel

[shreeram.maroo]

Hi,

I have a vba code for a user defined function that converts a given Arabic date into English date or vice versa. Can there be a way this formula would work in all the excel workbooks instead of working only in the workbook having this vba module. I have tried adding this module in personal.xlsb but it didn't work for me.

Regards
Shreeram

[HansV]

If you add the function to your personal macro workbook, you can use it by prefixing it with PERSONAL.XLSB:

=PERSONAL.XLSB!MyFunction(...)

[HansV]

Alternatively, create an add-in (.xlam), add the function to the add-in and install the add-in (File > Options > Add-ins, then click Go...)

[shreeram.maroo]

Thanks Hans.. the add ins worked !