Cyberdude
03-05-2006, 08:58 PM
If I have a utility macro that other of my macros all use, then I tend to store the utility macro in my Personal.xls workbook and create a reference to Personal.xls in all my other workbooks.
With that in mind, I also have some defined names for utility formulas which other workbooks use. I now copy all these defined names into each workbook. That seems less than elegant. I would like to be able (if possible) to store those special-case name definitions in Personal.xls in a fashion like I do with utility macros. How does one do such a thing (if possible)? :idea::sparkle: Keep in mind that these names are workbook independent, so there is nothing in them that makes them dependent on any one workbook in order to execute.
With that in mind, I also have some defined names for utility formulas which other workbooks use. I now copy all these defined names into each workbook. That seems less than elegant. I would like to be able (if possible) to store those special-case name definitions in Personal.xls in a fashion like I do with utility macros. How does one do such a thing (if possible)? :idea::sparkle: Keep in mind that these names are workbook independent, so there is nothing in them that makes them dependent on any one workbook in order to execute.