Loss of Right Button Functionality in Tabs

[Netorius77]

I have lost the right click functionality when I right click on an Excel Tab
(Excel 2003)

I can still right click in a cell and get the standard options (format, cut,
copy, insert etc), but when I right click on a tab to say copy tab, there is
nothing. Does anyone have a solution? Thanks

 

[Jacob Skaria]

--From the sheet hit the keys (Alt + F11) to launch VBE (Visual Basic Editor)
--Hit (Ctrl + G) so that Immediate window will be enabled
--Paste the below line including to the immediate window and enter (Make
sure you press Enter after placing the cursor end of the line)

Application.commandbars("PLY").Enabled = TRUE

--Now get back to workbook and check whether the Sheet tab right click works.

And then back to excel to test it.

 

[Jacob Skaria]

Still no luck ...you can try

Application.CommandBars("PLY").Reset

If this post helps click Yes

 

[Netorius77]

Perfect - great instruction and easy to follow. Thanks.