I'm teaching myself VBA, mostly on my Mac laptop and maximized the coding window for one of my modules. How do I get it out of this mode so I can switch back and forth between two modules easily?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
VBA for Mac coding window
0
Answers
0
Open the side window for "Project Explorer". That's where you can click on wherever you want to go.
Actually, the VB Editor window isn't designed or intended for single pane use. The panes you will need all the time, apart from the coding pane, are the Project Explorer, the Properties pane, the Immediate and the Locals panes. You can conveniently dock the latter two along the bottom edge of your screen and the former along the right, adjusting their size occasionally, rather than opening and closing them all the time.
Of course, that is easier on a larger screen. But then, the VB Editor wasn't designed or intended for laptop use, either lol:
Discussion
I think I might not have made my problem clear. The window that "Macro5() is in is my problem. I want to be able to tile macros but I can't get this one back.
baddog1016 (rep: 12) Jun 6, '20 at 8:43 pm
Macro5() is in a standard code module. All modules, standard and non-standard, are listed in the Project Explorer. Find the Project Explorer and you find the module. Once you are in any module you can use Edit > Find to locate any macro.
Variatus (rep: 4889) Jun 6, '20 at 10:30 pm
Ihave found that most of the time tht I full screen the code window there are icons in the upper right corner the same as used on a PC. For some reason this one macro did not have them so i copied and pasted the macro to a new one and deleted the one I couldn't minimize. Now I can once again tile my macros.
baddog1016 (rep: 12) Jun 21, '20 at 7:06 pm
Thanks for the feedback. This may indeed be useful to other users facing similar problems. Managing the VB Editor screen isn't very easy.
Variatus (rep: 4889) Jun 21, '20 at 8:53 pm