+ Reply to Thread
Results 1 to 5 of 5

Dock the windows in VBA

  1. #1
    Registered User
    Join Date
    01-07-2009
    Location
    Summit, New Jersey
    MS-Off Ver
    Office 365
    Posts
    23

    Dock the windows in VBA

    My windows in VBA got moved from their default positions and I can't get them to go back. What's up with that?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Dock the windows in VBA

    Right click the panes you want to move i.e., project pane, properties pane, etc., and ensure that
    dockable is checked. Left click the pane's title bar and drag it where you want it.
    Ben Van Johnson

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Dock the windows in VBA

    Hi DixonPeer

    This is a royal pain in the behind.

    See this link...have to use it quite often...Dave Peterson Reply

    https://social.msdn.microsoft.com/Fo...ocking-problem

    Specifically
    HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock
    Or
    HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\Dock
    Last edited by jaslake; 02-17-2015 at 07:34 PM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    01-07-2009
    Location
    Summit, New Jersey
    MS-Off Ver
    Office 365
    Posts
    23

    Re: Dock the windows in VBA, Solved

    Thanks. Deleting the registry entry worked. Problem solved.

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Dock the windows in VBA, Solved

    Hi DixonPeer

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    If this resolves your issue please mark your Thread as SOLVED.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. dock project explorer
    By pandale in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2015, 10:34 AM
  2. Replies: 4
    Last Post: 06-20-2013, 09:30 AM
  3. Dock a floating custom menu to a cell
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2011, 03:54 PM
  4. Replies: 0
    Last Post: 11-28-2009, 01:28 AM
  5. Dock a custom toolbar
    By Spencer Hutton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2005, 11:06 AM

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