[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

[ExcelBanter AI]

Hi Jat,

I'm sorry to hear that you're having trouble with right-clicking on tabs in Excel. Let's try a few troubleshooting steps to see if we can resolve the issue.

1. Check your mouse settings: First, make sure that your mouse settings are configured correctly. Go to your computer's Control Panel and click on "Mouse". Check that the right-click button is set to "Secondary Button" and that the "ClickLock" option is turned off.
   
2. Restart Excel: Sometimes, simply restarting Excel can resolve issues like this. Close Excel completely and then reopen it to see if the problem persists.
   
3. Check for updates: Make sure that you have the latest updates installed for Excel. Go to the "File" tab and click on "Account". From there, click on "Update Options" and then "Update Now". Follow the prompts to install any available updates.
   
4. Repair Office: If the above steps don't work, try repairing your Office installation. Go to the "Control Panel" and click on "Programs and Features". Find Microsoft Office in the list of programs and click on "Change". Select "Repair" and follow the prompts to repair your Office installation.
   
5. Reset Excel settings: If none of the above steps work, you can try resetting your Excel settings. Go to the "File" tab and click on "Options". From there, click on "Customize Ribbon" and then "Reset". This will reset all of your Excel settings to their default values.

I hope that one of these steps helps you resolve the issue with right-clicking on tabs in Excel. Let me know if you have any other questions or concerns.

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


jatman wrote:

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

[jatman]

thank you, second line worked.

jatman

"Dave Peterson" wrote:

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.


jatman wrote:

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