Using XLM Macro Sheet in Excel 2010

  • Thread starter Thread starter Jen
  • Start date Start date
J

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
 
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
Click to expand...

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
 
Back
Top