Enable Mouse Right Click functions

One thought...

I might be way off base, but since you say it is Excel only, could it be that the right-click event is disabled?

Have a look in the Workbook or Worksheet modules and see if there is anything resembling (this is a workbook level example):

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

Otherwise not sure, unless it's the mouse itself or some other protection against right-clicking that's placed those workbooks.

Good luck.

Tom Urtis

Re: One thought...

If that doesn't work you could try deleting the xlb file. The xlb file holds the modifications users make to the menus. Deleting it will return the menus to their original state.

If you do delete it you'll lose any personal menu settings you have.

Search the C drive for *.xlb if you want to have a go.

: I have two computers that have lost the right click : function in Excel, and Excel only. Is there a way : to enable that function?

Do you have Essbase installed on those PC's. If so open Excel, go to Essbase, Options, select the global tab, and remove the check on enable secondary button.

Re: One thought...

Appreciate the help. I found the xlb files and looked at the spreadsheets that were related to those files.
In those spreadsheets we found the lines that disabled the right click.
Ran the macro again and the problem went away.
Gary and Tom. Thanks for the help. : Cancel = True : End Sub :