Solved

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

Posted on 2014-02-03
10
636 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Move data from one sheet to another 11 32
Excel Conditional Median Problem 1 15
Excel Formula to split product code 5 16
Excel VBA User Form Help 21 28
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
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 create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

773 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