You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Excel, Word, or Outlook > Unable Right Click on Excel Sheet
Unable Right Click on Excel Sheet
print icon

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

  1. Enable command bars
  1. Close all Excel files. Check the Task Manager for any Excel files stuck open in the background.
  2. Open a blank Excel workbook.
  3. Press ALT+F11
    1. The Excel VBA Editor should open now.
  4. Press CTRL+G
    1. The ‘Immediate’ textbox should open near the bottom of the window
  5. Type ‘Application.CommandBars("Ply").Enabled = True’ into the ‘Immediate’ text box and press ‘Enter’.
  6. Press ‘ALT+Q’ to exit the VBA Editor
Feedback
0 out of 0 found this helpful

scroll to top icon