• 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.

VBA Icons disappeared

chirayu

Well-Known Member
Hi Guys,

Attached an image. No clue why the VBA menu icons have disappeared suddenly.

Was fine earlier. Tried closing excel/ restarting laptop. I'm using Excel 2013
 

Attachments

  • VBA Toolbar issue.png
    VBA Toolbar issue.png
    26.6 KB · Views: 9
It's usually fixed by closing and reopening VBE (not the Excel, though that should fix it as well).

Other than that, do ALT+V, then T (while in VBE). And see if there's check beside "Standard". If not click on it.

Edit: Ah, didn't see the very right of your screen shot. Looks like it's checked... Then, I suspect, it's detached from menu bar, and floating. Try adjusting screen resolution etc and see if you can bring it into screen area.
 
The issue seems to be with my extra screen. My laptop is connected to a secondary monitor. If I move the VB window to the other monitor then the button icons disappear. They are visible if I leave the window on main laptop screen. Guessing something to do with drivers
 
It's likely due to resolution mismatch between the two monitor.

Either set resolution on both monitor to be same. Or adjust monitor alignment to either align at top/bottom (you'll have to play to see which works for you), by click-and-dragging smaller of the two monitor.
 
Checked the resolution & setting - both are same. What I did find odd is if I drag the toolbar around in VBE then buttons show. When I hover over them they disappear again. the hover text is visible though
 
Back
Top