Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel VBA 24-Hour Trainer 2nd edition
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Excel VBA 24-Hour Trainer 2nd edition
This is the forum to discuss the Wrox book Excel VBA 24-Hour Trainer 2nd Edition by Tom Urtis; ISBN: 978-1-118-99137-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel VBA 24-Hour Trainer 2nd edition section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 12th, 2017, 11:29 PM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote
  #2 (permalink)  
Old May 14th, 2017, 09:59 PM
Wrox Author
Points: 45, Level: 1
Points: 45, Level: 1 Points: 45, Level: 1 Points: 45, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2011
Location: San Francisco / Silicon Valley
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Default Browser lowell Visual Basic 2005 Basics 0 March 23rd, 2007 09:36 PM
Find default browser lowell Beginning VB 6 2 March 22nd, 2007 09:21 AM
View Source from ActiveX Browser Object echovue Access 4 November 1st, 2005 01:13 PM
Launch default browser in a new browser window haiying Beginning VB 6 1 August 30th, 2005 06:48 PM
default browser dwz VB How-To 1 November 10th, 2003 08:55 AM



All times are GMT -4. The time now is 07:43 PM.


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