p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Excel VBA 24-Hour Trainer 2nd edition (http://p2p.wrox.com/book-excel-vba-24-hour-trainer-2nd-edition-786/)
-   -   VBE Object Browser Default View (http://p2p.wrox.com/book-excel-vba-24-hour-trainer-2nd-edition/99514-vbe-object-browser-default-view.html)

dbrdy May 12th, 2017 10:29 PM

VBE Object Browser Default View
 
I am just starting to work thru the Excel VBA Trainer and I was working in the VBE Object Browser when I changed the tiles and view. I'm trying to get it back to what it looks like on page 10 of the book but I can't seem to move the tiles in the right way. I have tried all the views such as horizontal, vertical etc, but nothing seems to work.

Any way to get it back to the default view? Thank you.

tomurtis May 14th, 2017 08:59 PM

I don't understand your question. Page 10 of the book is blank, after the last page of Lesson 1 and before the first page of Lesson 2. Also, it's not clear what you mean by default view, in terms of whichever way you are accustomed to seeing the VBE.

Regarding windows inside the Object Browser, you can maximize them or close them as you would with any window.

If you need a macro to maximize the VBE itself, this would do that. Before running this code, check to be sure you've established a reference in the VBE to Microsoft Visual Basic for Applications Extensibility 5.3.

Code:

Sub MaxVBE()
With Application.VBE.MainWindow
.SetFocus
.WindowState = vbext_ws_Maximize
.Visible = True
End With
Application.Visible = True
End Sub



All times are GMT -4. The time now is 03:00 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.