asked on

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

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

Joe Howard

1. Open personal.xlsb
2. View tab >> Hide >> Select personal.xlsb
3. Exit Excel, save if prompted

Nick Denny

ASKER

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.

MINDSUPERB

Have you tried closing them one by one? Then, open again the VBE?

Sincerely,

Ed

Nick Denny

ASKER

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.

SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nick Denny

ASKER

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:
https://www.experts-exchange.com/questions/28354903/Cannot-see-data-unless-zoom-is-less-than-100-plus-column-width-problems.html

Thanks

SOLUTION