Loss of Right Button Functionality in Tabs

  • Thread starter Thread starter Netorius77
  • Start date Start date
N

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
 
--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.
 
Still no luck ...you can try

Application.CommandBars("PLY").Reset

If this post helps click Yes
 
Back
Top