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
Enable a user defined formula in all excel
-
- 2StarLounger
- Posts: 181
- Joined: 19 Feb 2016, 16:54
- Location: Veraval, India
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Enable a user defined formula in all excel
If you add the function to your personal macro workbook, you can use it by prefixing it with PERSONAL.XLSB:
=PERSONAL.XLSB!MyFunction(...)
=PERSONAL.XLSB!MyFunction(...)
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Enable a user defined formula in all excel
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...)
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 181
- Joined: 19 Feb 2016, 16:54
- Location: Veraval, India
Re: Enable a user defined formula in all excel
Thanks Hans.. the add ins worked !