Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro library in XLSTART: Why does Excel 2007 fall over?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro library in XLSTART: Why does Excel 2007 fall over?
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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 does NOT keep vb library references ... | Excel Programming | |||
Excel 2007 Function Library | Excel Discussion (Misc queries) | |||
Excel macro security fails in directory XLSTART. | Excel Programming | |||
Are you telling me all a virus has to do is run from XLSTART toovercome Excel macro security? | Excel Programming | |||
XLStart in Office 2007 | Excel Discussion (Misc queries) |