Solved

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

Posted on 2014-02-03
10
668 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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 33

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
 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

630 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