right click does not work to tabs

J

jatman

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
 
D

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.
 
J

jatman

thank you, second line worked.

jatman

Dave Peterson said:
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.
Click to expand...
 
Top