Using XLM Macro Sheet in Excel 2010

[Jen]

Hi,
I was wondering if anyone knows a way to save a function defined in an
old style, XLM Macro Sheet, in personal.xls. Or to make sure that it
is loaded every time excel is started? Should I just put a shortcut
to my file in XLStart? Not sure of what the best way to do this is in
Excel 2010.
Thanks!
Jen

 

[James Ravenswood]

Hi,
I was wondering if anyone knows a way to save a function defined in an
old style, XLM Macro Sheet, in personal.xls.  Or to make sure that it
is loaded every time excel is started?  Should I just put a shortcut
to my file in XLStart?  Not sure of what the best way to do this is in
Excel 2010.
Thanks!
Jen

Strongly consider migrating to VBA. Microsoft has features in the
2010 version to facilitate this. See:

http://blogs.msdn.com/b/excel/archive/2010/02/16/migrating-excel-4-macros-to-vba.aspx