• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

menu bar has disconnected from the excel vba editor

M

mdavid

Member
Hi, When I go to Developer > Visual Basic I see the attached jpg - the menu bar has become disconnected from the main panel. How do I restore them to 1 unit?

Thanks for your help
Davidexcel-menu-bar.JPG
 
Thanks for this Hui, I stumbled upon your solution and it reconnected.
The problem now is getting back to the basic layout - all the vba editor windows are also independent of each other now, how do I get back to Projects and Properties on the left and the code pane on the right as a fixed group?
Appreciate your help
David
 
The easiest way is to close all menus and windows so that VBA looks like:
upload_2018-11-6_13-29-15.png

Then use the View menu to add back the project and Properties panes
upload_2018-11-6_13-30-37.png

You can also change the behaviour of window panes using the Tools, Options, Dockable menu
upload_2018-11-6_13-31-36.png
 
Thanks Hui,
still having problems trying to get the different panes under control. The project explorer pane now takes over the whole top half of the screen - I can adjust it vertically - changing the height, but it's not adjustable horizontally, so instead of being at the top left corner with properties below it's occupies the whole top half of the screen. The Properties appears correctly bottom left.
The whole vba editor seems to have taken on a life of its own!
Appreciate any help
David
 
mdavid said:
Thanks Hui,
still having problems trying to get the different panes under control. The project explorer pane now takes over the whole top half of the screen - I can adjust it vertically - changing the height, but it's not adjustable horizontally, so instead of being at the top left corner with properties below it's occupies the whole top half of the screen. The Properties appears correctly bottom left.
The whole vba editor seems to have taken on a life of its own!
Appreciate any help
David
Click to expand...
Just as an example, if I setup the project, properties and code windows correctly and then click on a form > view object , instead of the form opening on top of my layout, it replaces the project, properties, code windows and I have to start all over again!
 
Are the windows all set as Dockable as described above?

can you send a screen shot before and after and describe what you did in between?
 
You must log in or register to reply here.
Back
Top