Solved

.XLSB file in Windows 7 not loading on XLSTART

Posted on 2013-11-21
4
568 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

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

786 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