none
Office VBE toolbars missing RRS feed

  • Question

  • I have tried many solutions, none have worked.

    I also reinstalled office - but it must have picked previous settings.

    There is NO toolbar - so I cannot right click.

    Can anyone help, please.

    Monday, July 29, 2019 5:45 PM

All replies

  • Hello,

    You may find the Missing VBE Toolbars post helpful.


    profile for Eugene Astafiev at Stack Overflow, Q&A for professional and enthusiast programmers

    Monday, July 29, 2019 7:26 PM
  • Thanks for the reply. But, sadly, it did not solve my problem.
    Tuesday, July 30, 2019 11:15 AM
  • Have your tried Alt+v, to open the View menu,  then key t to see if your toolbars are not ticked as visible.

    If that doesn't work have a look at them with code and tinker!

    Sub VBEToolbars()
    Dim cBar As CommandBar
        For Each cBar In Application.VBE.CommandBars
            Debug.Print cBar.Name, cBar.Visible
            Select Case cBar.Name
            Case "Menu Bar", "Standard", "Edit"
               ' cBar.Visible = True
               ' cBar.Reset
               Debug.Print cBar.Name; cBar.Left, cBar.Top
            End Select
        Next
    End Sub


    Wednesday, July 31, 2019 7:51 AM
    Moderator
  • You could try resetting the VBA Editor's registry entries by deleting this key:

    HKEY_CURRENT_USER\Software\Microsoft\VBA\7.1\Common

    (7.1 may need to be changed, first create a backup!!!)

    The key will be reinstated with the default values once you restart the VBA editor.


    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com

    Wednesday, July 31, 2019 9:18 AM
  • Thanks so much for that.

    Yes, I have tried alt+v (or right click in project window) and it enabled me to get my toolbars back - and to insert modules etc - which is what I needed most of all!

    However it did not give me the toolbar "File  - - - etc". And I will try playing with the code you kindly supplied.

    Wednesday, July 31, 2019 9:19 AM
  • Peter Thornton,

    Your code shows that the menu bar is enabled.

    Therefore I think the problem is that it has, somehow, moved off screen?

    Do you know of any way of changing its location?

    Incidentally I am now unable to get the Immediate window (I had to alter your code to MsgBox)

    Jan Pieterse,

    Thanks for that - but it makes me nervous playing with the register - I have never done it!

    Cheers

    Wednesday, July 31, 2019 10:28 AM
  • If you are in the registry editor and have located the key (in the tree in the left-hand part of the registry editor window), right-click it, select "Export" and make sure you save the file somewhere you can find it easily, like your desktop or your documents folder. After that has been done you can safely just delete the key.

    Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com

    Wednesday, July 31, 2019 1:27 PM