+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 21 of 21

Docking Project Explorer Vertically

  1. #16
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Docking Project Explorer Vertically

    Hi
    Quote Originally Posted by Rob Bovey View Post
    Hi Chelsea,

    If you can't fix the problem any other way, here's the sledgehammer
    approach. Close Excel and open RegEdit (choose Start > Run, type RegEdit
    into the Run dialog and click OK). Navigate to the following registry key:

    HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common

    On the right side look for a registry entry called "Dock" of Type
    REG_BINARY. Double-click it to bring up the edit dialog, delete everything
    in the Value Data box and click OK. The data for the key should now say
    "(zero-length binary value)"
    Start Excel again and open the VBE. All of the windows sizes and docking
    positions should be reset to their defaults.

    --Rob Bovey, Excel MVP
    Application Professionals
    http://www.appspro.com/
    * Take your Excel development skills to the next level.
    * Professional Excel Development
    http://www.appspro.com/Books/Books.htm
    Quote Originally Posted by Peter T View Post
    HKCU-Software-Microsoft-VBA-Common-Dock
    typo,
    HKCU-Software-Microsoft-VBA-6.0-Common-Dock
    Peter T
    I can't seem to Rep or PM these guys to thank them, so just doing it in a reply, on the off-chance they are still subscribed: - This had frustrated me for Hours. The Reg Edit Tip did it. - And the first time in my life I was brave enough to mess with my Registry ...... and it worked.
    My VBA Project Explorer window and The Properties Window is finally back where it was !!!
    Thanks Rob Bovey ( and Peter and the others contributing )

    Alan
    Last edited by Doc.AElstein; 11-27-2016 at 05:50 PM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  2. #17
    Registered User
    Join Date
    12-16-2016
    Location
    Niantic,CT
    MS-Off Ver
    2007,2013
    Posts
    1

    Re: Docking Project Explorer Vertically

    Out of the blue I was having the same issue and was stuck with the Project Explorer and Properties windows docked and taking up the entire window and could not dock the code window. It was driving me mad. I found this solution and it fixed the issue. Thank You very much.

  3. #18
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Docking Project Explorer Vertically

    Quote Originally Posted by jabera10 View Post
    ..... I found this solution and it fixed the issue. Thank You very much.
    Yep Rob Bovey’s sledgehammer is the Doggy’s Nut‘s. Once again saved a lot of frustration. Just now my Immediate Window got “swallowed” and “eaten” as I moved over it whilst moving the position of my VB Editor Window. All I could do was open or close it after that. The problem was that on opening it, it took up all the entire space in the VB Editor but refused to let me reduce its size or move it in any of the ways that it usually is possible to do. ( So maybe the Immediate Window had sort of swallowed the VB Editor ?? ). In any case something had its knickers in a twist, and all the other ways to get the problem sorted had no effect !!

    Following the instructions from Rob Bovey sorted it Out
    Absolutely spiffing, Jolly Billy Ho! IMO

    Alan

    P.s. The thread is a bit Old so the exact steps may be a bit different..
    Here is one ( almost) current example...
    ( Using Windows Vista )

    _ 1) Close Excel ***
    _ 2) Hit the Microsoft symbol bottom left
    _ 3) Type in RegEdit in the small search Window
    _ 4) Double click on the RegEdit which should now be offered in the larger window just above the Search Window
    ( _ 5)( At this point I got an “Administrator Rights” type window pop Up – So you might not get past here depending on your “rights” – I got past by just clicking OK in this pop Up ) )
    _ 6) A big registry Window pops up – I navigate through HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
    _ 7) Now on the right side of the Registry, I see a Dock . I double click on Dock
    _ 8) I have now an Edit Window. It has a large “Value:” Box full with Numbers and letters in it.
    _ 9) I Highlight all those Numbers and delete them, ( All but 0000 should then vanish ) , then Hit OK
    _ 10) – “Jolly Ruddy Spiffing Billy Merry Ho Wonks Bingo !!” . – On opening Excel I find if I hit Ctrl+G from the VB Editor ( Alt+11 ), my immediate Window appears at the bottom of the VB Editor, but I can drag it in and out of the VB Editor anywhere where I Jolly well like!

    (*** Do not forget that Excel must be closed or it will not work )

    RegEditDockingWonks.JPG http://imgur.com/V0qttoA
    RegEditDockingWonks.JPG

    P.P.s. May be this Thread could do with being in the Tips and Tutorials Sub Forum?
    Last edited by Doc.AElstein; 12-20-2016 at 11:23 AM.

  4. #19
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Docking Project Explorer Vertically

    Quote Originally Posted by Doc.AElstein View Post

    P.P.s. May be this Thread could do with being in the Tips and Tutorials Sub Forum?
    This thread could do with being nominated for a Nobel Peace Prize. Thank you so much guys who came up with this solution, this bug was driving me bananas (what did people used to do in the 80s and 90s when things like this happened?)

  5. #20
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,426

    Re: Docking Project Explorer Vertically

    Quote Originally Posted by bevc View Post
    ...what did people used to do in the 80s and 90s when things like this happened?)
    I worked for a fairly large Electronics company back then… when things went wrong with anything to do with a computer or software we went to the Computer Department, aka, Dave James, and he fixed it, usually on the spot.
    Things were less complicated back then
    Things seem to go wrong when Design / Development Teams expanded past more than a few people, Lol….

  6. #21
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Docking Project Explorer Vertically

    Quote Originally Posted by Doc.AElstein View Post
    I worked for a fairly large Electronics company back then… when things went wrong with anything to do with a computer or software we went to the Computer Department, aka, Dave James, and he fixed it, usually on the spot.
    Things were less complicated back then
    Things seem to go wrong when Design / Development Teams expanded past more than a few people, Lol….
    Funnily enough my dad says something similar, he used to fix mainframes back in the 80s, and I asked him this, and he said a good analogy would be with cars - these days, nobody knows how to fix a modern car. But back in the 40s or 50s, if you owned a car, chances were very good that you had a rudimentary idea how to fix it, and how it worked, because, well, for one, if you opened the hood there was a good chance you could see what was happening.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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