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