right click does not work to tabs

[Guest]

up until last week, the right click used to work on the tabs along the
bottom. now when i try to right click on the tab, nothing happens. the
mouse works everywhere else, except on the tabs.

issue exists in all areas (new workbook, old workbook/sheet)

jat

 

[Dave Peterson]

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Then type this and hit enter:
application.commandbars("ply").enabled = true

Then back to excel to test it.

If it doesn't work, back to the immediate window in the VBE and
type this and hit enter:
application.commandbars("ply").reset

And then back to excel to test it.

 

[Guest]

thank you, second line worked.

jatman

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Then type this and hit enter:
application.commandbars("ply").enabled = true

Then back to excel to test it.

If it doesn't work, back to the immediate window in the VBE and
type this and hit enter:
application.commandbars("ply").reset

And then back to excel to test it.