Results 1 to 2 of 2

Problems with Arranging Windows in VBA editor

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2010
    Location
    Leicester, England
    MS-Off Ver
    Word, Excel, Acess, PowerPoint 2007
    Posts
    5

    Problems with Arranging Windows in VBA editor

    Not sure TBH whether this belongs here or in EXCEL GENERAL. It's a bit like asking how you hold the Janet and John book before learning how to read! But this is driving me mad.

    I recently moved to a new computer and moved to Office 365 for Business from 365 Professional Plus (latest versions).

    On my old machine (still running), if I open the VBA editor in Excel the windows are neatly arranged and docked together - Project Explorer and Properties windows on the left filling about one quarter of the screen width and the code window filling the remainder. Neat tidy and everything easily accessible.

    On my new computer every window - including FIFTEEN modules that are part of PERSONAL.XLSB - open up separately - i.e. floating. If I expand and then collapse the PERSONAL.XLSB VBA Project in the project explorer that quickly gets rid of all 15 of the code windows for the PERSONAL modules - so I can cope with that. It would be much nicer if these didn't open at all, but I presume that's not doable!

    My much greater aggravation is to get the Project explorer and the Properties Windows to remain on the left side docked together. If I check the boxes for docking these windows in TOOLS|OPTIONS (or use right click) the Project Explorer window DISAPPEARS COMPLETELY! WINDOWS|CASCADE won't bring it back. The Properties window remains but I can only dock it to the top of the screen and then it sits across the entire width. The only way to get back the Project explorer is to uncheck docking in TOOLS|OPTIONS. It is as if this window moves somewhere off the monitor!

    So I am left with the only option of undocking both boxes and arranging them as floaters on the left side. I have followed several suggested procedures for arranging these windows online but just cannot solve it. Anyone any ideas at all?

    Thanks
    Last edited by Graydjames; 08-26-2019 at 08:03 AM. Reason: Errors made found on review

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can't open 2 VBA Editor windows in Excel 2016
    By Arkadi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2019, 11:00 AM
  2. [SOLVED] F8/F5, etc. not working in VBA editor (HP Windows 7 machine)
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2015, 01:52 PM
  3. arranging windows
    By hobscons in forum Excel General
    Replies: 2
    Last Post: 07-28-2006, 04:40 PM
  4. [SOLVED] Arranging VBA windows
    By Hari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2006, 02:00 PM
  5. Here is fix for Windows file problems
    By Patricia Shannon in forum Excel General
    Replies: 0
    Last Post: 04-14-2006, 08:10 PM
  6. Arranging 3 windows ... Regardless of Monitor Size
    By monir in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2006, 03:55 PM
  7. Arranging Windows
    By J Streger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1