DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Software Q&A

Costum formula in excel

3 posts · originally from https://geek.digit.in/community/threads/costum-formula-in-excel.100613/

Cool Buddy
Cool Buddy Original post #1
Oct 25, 2008 at 9:02 PM
I used this page's code to define a formula in excel. however the formula is appearing only in the workbook that is open at that time. how to use the formula across excel?

In case you want to try the formula, remove the two _ (undescores) and the line break after that to get the code working.
Cool Buddy
Cool Buddy #2
Oct 26, 2008 at 9:25 PM
Where are the techies of digit? i really want a solution, is it possible at all? can the mods help?
Cool Buddy
Cool Buddy #3
Nov 8, 2008 at 1:11 PM
I am still wondering why there was not a single reply to this post. however, I found a solution, i copied the code to the workbook where excel stores macros when we store it outside the workbook (personal.xlsb in excel 2007). now the formula appears in all workbooks (prepended with the workbook's name).