MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Enable Mouse Right Click functions


Posted by William on December 17, 2001 12:34 PM

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

Appreciate the help. Thanks


Posted by Tom Urtis on December 17, 2001 1:09 PM

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

Posted by Gary on December 17, 2001 1:23 PM

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?

Posted by Jerid on December 18, 2001 5:03 AM

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.

Posted by William on December 18, 2001 5:16 AM

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 :