How to Enable Right Click Menu on Sheet Tab?

Hi putritersenyum

To turn on the Right Click Menu, in the Immediate Window type this and hit Enter

application.CommandBars("Cell").Enabled = true

Edit...I may have misunderstood...the above is to reset the Right Click on a Cell.

To reset the Right Click on a Tab, in the Immediate Window type this and hit Enter

Application.CommandBars("Ply").Enabled = True

Glad it worked for you Noel 1123

Hi putritersenyum

No...it's as simple as this...

Hi putritersenyum

Run this Code on your Workbook

Sub ShowNames()
   Dim ContextMenu  As CommandBar
   Dim ctrl         As CommandBarControl

   Set ContextMenu = Application.CommandBars("Ply")
   For Each ctrl In ContextMenu.Controls
      Debug.Print ctrl.Caption
      ContextMenu.Controls(ctrl.Caption).Enabled = True   'For Tabs
   Next ctrl
End Sub

Hi putritersenyum

If you like, I'll look at the File...please upload it...

Sarvesh1608 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Originally Posted by ChinmayBari

I did everything. .Still not working

Hello try this code

Sub Reset_All_CommandBars()
    Dim myBar    As CommandBar
    
    For Each myBar In Application.CommandBars
        If myBar.Type = msoBarTypePopup Then
            myBar.Reset
            myBar.Enabled = True
        End If
    Next myBar
End Sub

Originally Posted by ChinmayBari

I did everything. .Still not working

Perhaps you missed my post #13?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hi,

Close Excel and search your computer for an Excel.xlb file (there will be a number included for your excel version, e.g. Excel12.xlb)- ensure you are including hidden folders in the search. If you find one, either delete it or move it to another location, and then start Excel and see if the situation has improved.