Solved

.XLSB file in Windows 7 not loading on XLSTART

Posted on 2013-11-21
4
579 Views
Last Modified: 2013-11-27
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!
0
Comment
Question by:mak345
  • 3
4 Comments
 
LVL 17

Expert Comment

by:Chris Millard
ID: 39665819
You might need to adjust the macro settings in the Excel trust-centre
0
 

Author Comment

by:mak345
ID: 39665841
Thanks, but I did enable all macro settings in the trust center.
0
 

Accepted Solution

by:
mak345 earned 0 total points
ID: 39666945
Well, I was able to figure it out.  Basically, all I did was open the .xlsb file, hide it, and then link the macros to icons.  When I reopen Excel, and hit ALT-F11 to bring up VBA Editor, it does not appear that the macros are available.  This is why I thought it wasn't working.  However, when I actually click an icon, the macro runs, and I can then see the macro in VBA editor.  The workbook also stays hidden as I want it too.
0
 

Author Closing Comment

by:mak345
ID: 39680227
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..
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question