Solved

Personal.xlsb code modules all opening every time I open the VBA Editor

Posted on 2014-02-03
10
628 Views
Last Modified: 2014-02-23
Hi Experts

I have just upgraded from XP to Windows 8.1 and now in Excel 2007, every time I open the VBA Editor, all the code modules from my personal.xlsb are open.
This behaviour never happened in XP so I am guessing it is possible to "switch off".

I have my personal.xlsb in the XLStart folder as I did in XP.

I do want it available, but not all the code windows opening.

Thanks in advance

Nick
0
Comment
Question by:Nick Denny
10 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39829051
1. Open personal.xlsb
2. View tab >> Hide >> Select personal.xlsb
3. Exit Excel, save if prompted
0
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829112
Thanks for response.
Personal.xlsb is already hidden.
My challenge is when I open the VBE (Alt+F11) the code windows are all open.
I would prefer them all to be closed.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 39829179
Have you tried closing them one by one? Then, open again the VBE?

Sincerely,

Ed
0
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829261
Thanks Ed, yes I tried that and they still all remain open.

However, unless there is some way of doing this natively, I am using the "hide windows when collapsing the project" option in the tools menu.

This will do I suppose as its only a click of the mouse.

Thanks again.

I will leave a while in case there is an option somewhere.
0
 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
ID: 39829337
Might seem a daft question but after closing the windows in the VBE, are you saving the file?

Thanks
Rob H
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 13

Author Comment

by:Nick Denny
ID: 39829376
I am clicking the "save" icon  in the VBE and it is still displaying the same when I reopen Excel.
When I first posted, the tiles were randomly all over the VBE, now for some reason at least they are neatly stacked????

It seems I am having a few issues with Excel, so this may be a reinstall job.

Another q:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28354903.html

Thanks
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 250 total points
ID: 39832155
Clicking Save in the VBE is flaky at best. Once you have collapsed the project, use:
Workbooks("Personal.xlsb").Save

Open in new window

in the Immediate window.
0
 
LVL 13

Accepted Solution

by:
Nick Denny earned 0 total points
ID: 39837527
Thanks Rory. I tried your suggestion but all windows are still open when restarting Excel.
However, as said, a simple click to collapse gets rid when they are not wanted.

Is it actually possible to start the VBE with the all projects collapsed?

I have tried starting Excel with a blank workbook, no workbook (the  /e option), and direct through file association.

All results are the same for me.

Thanks

Nick
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39837579
Strange - that method works for me.
0
 
LVL 13

Author Closing Comment

by:Nick Denny
ID: 39880386
Thanks for all input.
Things seem to have settled down so long as I collapse the Personal project.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

896 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now