[Excel] No Context Menu In VBA

[agmorgan]

I know there used to be an issue with mouse drivers not scrolling the VBA editor, however, I am now seeing a different issue.
I CAN scroll, but I can't get a context menu to appear at all in the editor.

I am using Vista SP1, Office 2007, MZTools and a Microsoft Intellimouse Optical.

[agmorgan]

I uninstalled MZTools and restarted Excel just in case but it hasn't helped.
The menu comes up if I press Shift-F10, but not on right-click.
It DOES appear on right-click within a spreadsheet though (just in case anyone thought my mouse was bust).

[agmorgan]

I finally managed to hack my way around it.
I downloaded the latest intellimouse software and made use of the Enable program-specific settings.
I added Excel to the list because there was no option to just add the VBA editor (I guess it is compiled into Excel instead of being a separate app)
Then I changed the right button to Keystroke = Shift + F10

For some reason this works, but as soon as I reset it back to Right-click(default) the context menu no longer appears again.

This implies that it isn't really a mouse issue, but perhaps some setting in Excel that is preventing the right-click from showing the context menu.

I'll leave the thread unresolved until I can find out what that setting is!

[haydoon]

Hey agmoran,

We had this problem too

This is a weird problem, and I expected to find many more people experiencing it when I first discovered we had the same...

Do you have a second monitor? - We've just found that right click doesn't work in the VBA editor in a multi-monitor setup where the VBA editor is on the second monitor.

Move the VBA editor onto my primary monitor (I use a laptop) and on the laptop screen the right click works...

I wonder if you have a similar situation?

[haydoon]

I've just looked into this a bit more, and here's what I see on my system
(Laptop monitor with a second (VGA connector) HD monitor)

- right click in VBA editor doesn't work properly on my second monitor if I use an extended desktop, where my secondary monitor is larger than the primary monitor.

- It doesn't work at all if my secondary is positioned above the primary (laptop bottom, second monitor on top), and half works if the secondary is positioned to the right.

- if I have a right/left, primary/secondary, extended desktop, the right click works so long as I click in the bottom section of the screen (I imagine it would work fine if my displays were the same size)

- if I reverse the primary/secondary, (monitor on top is primary, laptop on bottom is secondary) then it seems to work fine on both screens

Hope this helps! - took a while to think to try it on the other screen...