Jan 21, 2022
Unable to right-click an Excel sheet tab
Issue
Right-clicking on an Excel sheet tab does nothing
Cause
Unknown
Possible Resolutions
Save before beginning
Test after each section
- Enable command bars
- Close all Excel files. Check the Task Manager for any Excel files stuck open in the background.
- Open a blank Excel workbook.
- Press ALT+F11
- The Excel VBA Editor should open now.
- Press CTRL+G
- The ‘Immediate’ textbox should open near the bottom of the window
- Type ‘Application.CommandBars("Ply").Enabled = True’ into the ‘Immediate’ text box and press ‘Enter’.
- Press ‘ALT+Q’ to exit the VBA Editor