Forum Discussion
Context menu immediately closing after opening
When I try to open the context menu using my mouse, trackpad or keyboard button it opens and immediately closes again. It only happens when a certain workbook is open, also effecting all other excel ...
This behaviour (context menu instantly closing, focus snapping back to the workbook, VBA window refusing to stay focused, etc.) is almost always caused by one of three things:
a broken or invisible UserForm that is being kept modeless
a stuck event handler (even if macros are disabled now)
a corrupted workbook window state
Check if a hidden/active UserForm is blocking input
Check for a stuck event handler
Check for window corruption
Open the workbook in Excel Safe Mode
Check for an endless BeforeRightClick event
If none of the above fixes it
- Does it happen with only one workbook?
- Does it happen even after you copy all sheets to a new workbook?
- Does it occur if you upload the file here?
Your description matches either a hidden modeless UserForm or Application.Interactive = False.
Hope this helps you.