Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603

Posted on by Annie D

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: https://www.mrexcel.com/youtube/C4T9CDfVA5g/

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comThu, May 25, 2023 2:11pm