Link to home
Start Free TrialLog in
Avatar of mak345
mak345Flag for United States of America

asked on

.XLSB file in Windows 7 not loading on XLSTART

I just got upgraded to Windows 7 from Windows XP Professional.  In the past, I had a .xlsb file located in C:\Program Files\Microsoft Office\Office 14\XLSTART.  Each time I started Excel, this file would load as hidden and I had macros I was able to link to icons in my customized quick access toolbar.

Now that I have upgraded, I wish to be able to do the same.  I used the ? Application.StartUpPath in VBA Immediate Window to determine the new path which told me:  C:\users\*username*\AppData\Roaming\Microsoft\Excel\XLSTART\.

However, when I start Excel, it is not working.

Not sure what I am doing wrong.

Thanks!
Avatar of Chris Millard
Chris Millard
Flag of United Kingdom of Great Britain and Northern Ireland image

You might need to adjust the macro settings in the Excel trust-centre
Avatar of mak345

ASKER

Thanks, but I did enable all macro settings in the trust center.
ASKER CERTIFIED SOLUTION
Avatar of mak345
mak345
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mak345

ASKER

Seems to work as expected.  I don't know why it doesn't show up in VBA when Excel starts, but it's there when I run a macro..