VBA modules

richarddawson

Board Regular
Joined
Oct 18, 2014
Messages
95
I like to set my modules (except Project Explorer and Immediate) all to the maximum size, leaving room at each side for those two exceptions.

That is fine, and easy.

However when I save and then reload most (or, perhaps, all) have been resized.

Is there any way I can stop this happening?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Not sure what you mean exactly - Project Explorer and Immediate are windows, not modules. Can you perhaps post screenshots of what you have vs what you want?
 
Upvote 0
Not sure what you mean exactly - Project Explorer and Immediate are windows, not modules. Can you perhaps post screenshots of what you have vs what you want?
1724326967972.png

That is how I like my screen to appear.
But when I save, close, and reopen, this is how it appears
I can't post it, too big. So will post this and then put another post up.
 
Upvote 0
It looks like you just need to maximise the code window.
 
Upvote 0
Yes. But if I do that on the button it overwrites the Project Explorer and Immediate windows.
I can, of course, drag them to the size I want, but the system I am working on has 26 modules - and it is a bore having to resize them all whenever I reload.
However I can live with it if I have to!
 
Upvote 0
You need to dock the Project Explorer and Immediate Window using Tools - Options - Docking tab. If you do that, the code window will only fill up the space between them.
 
Upvote 0

Forum statistics

Threads
1,221,487
Messages
6,160,118
Members
451,619
Latest member
KunalGandhi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top