Microsoft Excel Tutorial: The VBA Editor Panes are missing or not docked correctly.
Chris writes in. His VBA Editor is completely grey. How does he get back to the classic view with the Project Explorer in the Top Left, the Properties window in the bottom left and the Code on the right?
To download this workbook: Excel VBA Window is All Grey Or Panes Will Not Redock Correctly - Episode 2603 Sample Files - MrExcel Publishing
Table of Contents
(0:00) Program Note
(0:11) Excel VBA Editor is all Grey
(0:50) VBA Panes not docking correctly
(0:55) Undocking VBA Pane
(1:08) Look for "Ghost" panel to redock
(1:28) Excel VBA Pane redocks full width
(1:46) VBA Editor no room for code pane
(1:56) Undock the Project Explorer
(2:08) Undock Properties Pane
(2:15) Dock Properties to Project Explorer
(2:30) Change Split Window in VBA
(2:44) Re-dock both windows
(3:00) View Code Pane in Excel VBA
Chris writes in. His VBA Editor is completely grey. How does he get back to the classic view with the Project Explorer in the Top Left, the Properties window in the bottom left and the Code on the right?
To download this workbook: Excel VBA Window is All Grey Or Panes Will Not Redock Correctly - Episode 2603 Sample Files - MrExcel Publishing
Table of Contents
(0:00) Program Note
(0:11) Excel VBA Editor is all Grey
(0:50) VBA Panes not docking correctly
(0:55) Undocking VBA Pane
(1:08) Look for "Ghost" panel to redock
(1:28) Excel VBA Pane redocks full width
(1:46) VBA Editor no room for code pane
(1:56) Undock the Project Explorer
(2:08) Undock Properties Pane
(2:15) Dock Properties to Project Explorer
(2:30) Change Split Window in VBA
(2:44) Re-dock both windows
(3:00) View Code Pane in Excel VBA
Transcript of the video:
Hey, good morning. I've managed to hide two videos in this video.
The first one is “all the panes are missing from the VBA window”.
The second one is, “they're there, but they're not docking correctly”.
Watch them both. Thanks. Chris writes in today, his VBA Editor window is all gray. And our goal is to have this classic view.
Project Explorer, top left. Properties window, bottom left.
Code window on the right-hand side. But Chris is just seeing this.
All right, in theory, this should be easy, three keystrokes.
Let's do Alt+F11 to get to the VBA.
You go View, Project Explorer first, which gets that over on the left.
Then, View, Properties Window, which gets it down below.
And then, View, Code, which gets the code window on the right.
And, of course, you can say View Code to see one particular macro there. But, sometimes, it doesn't work right.
So let's talk about the VBA panes are not docking correctly.
So many times, I managed to accidentally screw this up.
So it's possible to undock something just by grabbing the title bar and dragging it into the middle.
And then, when you go to redock it, the whole trick is to drag it over until the mouse pointer is just outside the window.
And you get this little ghost that appears back there.
All right, so this ghost is saying that the project window is going to take up the entire height of the left side like that.
But it's also possible, if you're not careful, to accidentally drop it too high. Oh, and then we take up the entire width.
If you manage to do this, yeah, just chaos will ensue.
And then, when you do the next item, the Properties Window, who knows where it's going to go.
It's possible to drag that off, and drag it back in the wrong spot. Now, we have this weird thing.
And then, when we go to View, Code, there's no room for the code window.
All right, when this happens to me, I think the best solution here is, first, just start with the Project Explorer. Undock it, and get it to be about that size.
Don't let it redock yet. And then go to View, Properties Window.
Undock that.
All right, and now what we want to do is, we want to dock the Properties window to the Project window.
So very carefully, just drag it right up there. Ah, perfect.
It doesn't look like it's perfect, but it really is.
All right.
We're going to resize this whole set of two docked windows. And then, it's hard for me to see.
I just have to get to the point where I get that symbol.
All right, so we're just taking the mouse until we hit that handle.
Then, I can resize it so, that way, the Project gets about two thirds, the Properties gets one third.
And then, very carefully, drag this whole thing off the side, where we get the vertical ghosting like that.
You don't want to drop it where you get the horizontal ghosting.
So right there, perfect.
And then, when we do View, Code, the Code should go back to the right spot.
It's frustrating when you've broken it and it doesn't want to just redock. Because it happens, what, once every five years?
And you never remember the steps.
Well, now, you'll just have to bookmark this video to come back and do that.
Well, I want to thank Chris for sending that question in. And I want to thank you..
We'll see you next time for another netcast from MrExcel.
If you like these videos, please, down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
The first one is “all the panes are missing from the VBA window”.
The second one is, “they're there, but they're not docking correctly”.
Watch them both. Thanks. Chris writes in today, his VBA Editor window is all gray. And our goal is to have this classic view.
Project Explorer, top left. Properties window, bottom left.
Code window on the right-hand side. But Chris is just seeing this.
All right, in theory, this should be easy, three keystrokes.
Let's do Alt+F11 to get to the VBA.
You go View, Project Explorer first, which gets that over on the left.
Then, View, Properties Window, which gets it down below.
And then, View, Code, which gets the code window on the right.
And, of course, you can say View Code to see one particular macro there. But, sometimes, it doesn't work right.
So let's talk about the VBA panes are not docking correctly.
So many times, I managed to accidentally screw this up.
So it's possible to undock something just by grabbing the title bar and dragging it into the middle.
And then, when you go to redock it, the whole trick is to drag it over until the mouse pointer is just outside the window.
And you get this little ghost that appears back there.
All right, so this ghost is saying that the project window is going to take up the entire height of the left side like that.
But it's also possible, if you're not careful, to accidentally drop it too high. Oh, and then we take up the entire width.
If you manage to do this, yeah, just chaos will ensue.
And then, when you do the next item, the Properties Window, who knows where it's going to go.
It's possible to drag that off, and drag it back in the wrong spot. Now, we have this weird thing.
And then, when we go to View, Code, there's no room for the code window.
All right, when this happens to me, I think the best solution here is, first, just start with the Project Explorer. Undock it, and get it to be about that size.
Don't let it redock yet. And then go to View, Properties Window.
Undock that.
All right, and now what we want to do is, we want to dock the Properties window to the Project window.
So very carefully, just drag it right up there. Ah, perfect.
It doesn't look like it's perfect, but it really is.
All right.
We're going to resize this whole set of two docked windows. And then, it's hard for me to see.
I just have to get to the point where I get that symbol.
All right, so we're just taking the mouse until we hit that handle.
Then, I can resize it so, that way, the Project gets about two thirds, the Properties gets one third.
And then, very carefully, drag this whole thing off the side, where we get the vertical ghosting like that.
You don't want to drop it where you get the horizontal ghosting.
So right there, perfect.
And then, when we do View, Code, the Code should go back to the right spot.
It's frustrating when you've broken it and it doesn't want to just redock. Because it happens, what, once every five years?
And you never remember the steps.
Well, now, you'll just have to bookmark this video to come back and do that.
Well, I want to thank Chris for sending that question in. And I want to thank you..
We'll see you next time for another netcast from MrExcel.
If you like these videos, please, down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
