Excel 2010 VB pane docking problem

User avatar
sobershea
2StarLounger
Posts: 184
Joined: 08 Feb 2010, 23:37
Location: Howell, Michigan USA

Excel 2010 VB pane docking problem

Post by sobershea »

Somehow I have altered the default view in VB. It used to open with the Project Explorer on the left side the and the Code Pane on the right side. Now the Code Pane is on the bottom and the Project Explorer is on top and even if I close all panes then open the Code pane followed by the Explorer pane, it still ends up the same way. I checked in Tools, Docking and everything was checked. I unchecked everything and then I can arrange the panes the way they used to be but I don't think unchecked is the default. I also saw a similar question online and the response was to delete the Registry Code HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock and Excel would go back to default. This answer was for Office 2003. I checked and I have that key as well as a similar key HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\Dock. After exporting both keys I tried deleting them but that didn't change anything. I would like to get the viewer back to normal. Any ideas?

TIA
Sherry

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel 2010 VB pane docking problem

Post by HansV »

See if Jan Karel Pieterse's tips in Docking VBE Windows help. Post back if not.
Best wishes,
Hans

User avatar
sobershea
2StarLounger
Posts: 184
Joined: 08 Feb 2010, 23:37
Location: Howell, Michigan USA

Re: Excel 2010 VB pane docking problem

Post by sobershea »

That did the trick. Thanks Hans.
Sherry