Macro library in XLSTART: Why does Excel 2007 fall over?

[Allen_N]

I just ported a macro library (and the workbooks that use it) from Excel 2003
to 2007, hoping that Microsoft would not have created unreasonable obstacles
to making the library available to all users. Hah.

I saved my library as a 2007 macro-enabled workbook ("Custom.xlsm") and
moved it to the (Vista) folder "C:\Program Files\Microsoft
Office\Office12\XLSTART". However, this causes Excel crash on start-up.

After moving Custom.xlsm out of XLSTART I got Excel to work again, and I can
manually open Custom.xlsm, so I have a work-around. But, what good is the
XLSTART folder if Excel breaks when it finds some macros in there?

Perplexed,

Al

 

[FSt1]

hi
i think it's suppost to be a .xlsb extention, not a .xlsm. and change the
name to personal.xlsb not custom.xlsm.

regards
FSt1

 

[Allen_N]

Thanks FSt1,

But I don't want my shared library to have to be copied (and maintained) in
every user profile on the machine. That's why I kept it separate from
PERSONAL.XLS when it was in Excel 2003.

I'll try renaming the extension to XLSB, though.

 

[Dave Peterson]

Maybe there's something wrong with custom.xlsm.

If you create a test macro enabled workbook and save it in the same location, do
you have the same trouble?