VBA window sometimes opens very small

mcomp72

Active Member
Joined
Aug 14, 2016
Messages
308
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
When I open my Macro-Enabled workbook and then click Developer -> Visual Basic, the VBA window sometimes opens extremely small. It doesn't always do it, but I'd say around every 5th or 6th time I open the VBA window (when Excel has just been launched) it will do this. Anyone ever have this problem, and if so, any clue how to get it to stop doing this?

Here's a pic of how small the VBA window is when it happens.

Screenshot-106.png
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
I haven't had it with the VBA window, but I know that if I shut down the application while the Excel window is diminished, I can expect Excel to open with a smaller screen. My editor screen pretty much stays whatever size it was that I resized it to when I last used it. But with these later versions of Excel, I am not sure what would affect the sizing of the editor screen.
 
Upvote 0
I have the same issue, think it may have started after the last update. It's not the end of the world but frustrating!

I use dual monitors, wonder if that has anything to do with it? The Editor opens on the primary monitor when it does the small open change... I usually open the editor on the secondary monitor. If I open and close the editor... it always open correctly (on the secondary monitor). I think it is when all excel files are closed... upon re-opening, that's when I get the small look on the primary monitor in the top left corner.

Would be nice to get a solve for this...

Craig
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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