Loss of Right Button Functionality in Tabs
 

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

Loss of Right Button Functionality in Tabs
 

--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.
--
If this post helps click Yes
---------------
Jacob Skaria


"Netorius77" wrote:

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

Loss of Right Button Functionality in Tabs
 

Still no luck ...you can try

Application.CommandBars("PLY").Reset

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

--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.
--
If this post helps click Yes
---------------
Jacob Skaria


"Netorius77" wrote:

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

Loss of Right Button Functionality in Tabs
 

Perfect - great instruction and easy to follow. Thanks.

"Jacob Skaria" wrote:

--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.
--
If this post helps click Yes
---------------
Jacob Skaria


"Netorius77" wrote:

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