Right click disabled

[LiAD]

In excel the right click on my mouse does not work anymore.

Anyone know how I reset this?

Thanks

 

[Benji]

I have a couple of questions for you so I can help diagnose the problem.
Remember that if you assume that you have checked or have left out any
information relative to the problem, it is unlikely anyone will be able to
help.

Is this a problem only for Excel? If not, the problem likely lies within
your hardware, whether that be the port or mouse is another matter. It is
also possible if you are not your system admin that the right click feature
has been disabled.


Any other information that you may find relavent will help us help you.

 

[LiAD]

The problem is only in excel.

The problem has occurred after i used the following event code (first code
below) to disable all toolbars and menu's. The event cause ALL OF MY EXCEL
FILES to change not just the one i was working on. The code was entered as a
workbook event code by clicking on the top right corner of the excel near the
file menu.

In order to unlock excel and be able to use it again I used the second short
code and from there I can then reconfigure my menus etc, or almost anyway.
The biggest item I am missing is the right click feature on the mouse.

Is that enough info or do you need more details?

Thanks a lot for your help. I'm well stuck!
LiAD
-------------------------------------------------
Private mFormulaBar

Private Sub Workbook_BeforeClosex()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB

Application.DisplayFormulaBar = mFormulaBar
End Sub

Private Sub Workbook_Open()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next oCB

mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub
---------------------------------------------------------
Sub RemoveMacro()

Application.CommandBars(1).Enabled = True

End Sub
---------------------------

 

[LiAD]

Solved thanks to a link from this site.

Excellent now i can work again!

http://forums.microsoft.com/smallBusiness/MigratedForum.aspx?siteid=22&PostID=3048404