#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 386
Default Right click disabled

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

Anyone know how I reset this?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Right click disabled

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.
--
Learning without thought is labor lost.

Thought without learning is perilous.


"LiAD" wrote:

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

Anyone know how I reset this?

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 386
Default Right click disabled

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

"Benji" wrote:

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.
--
Learning without thought is labor lost.

Thought without learning is perilous.


"LiAD" wrote:

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

Anyone know how I reset this?

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 386
Default Right click disabled

Solved thanks to a link from this site.

Excellent now i can work again!

http://forums.microsoft.com/smallBus...PostID=3048404

"LiAD" wrote:

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

"Benji" wrote:

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.
--
Learning without thought is labor lost.

Thought without learning is perilous.


"LiAD" wrote:

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

Anyone know how I reset this?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Right Click Pop Up Menus Disabled Steve Excel Discussion (Misc queries) 5 May 5th 08 08:34 PM
Unable to use right-click on cells; standard and formatting toolbars disabled Trizi Excel Discussion (Misc queries) 3 June 22nd 07 04:17 AM
Excel: can "go to adjacent empty cell" double-click be disabled? dgg2006 Excel Discussion (Misc queries) 1 April 8th 06 04:51 AM
Lost Toolbar / Right click disabled Anthony Excel Discussion (Misc queries) 4 August 4th 05 01:17 PM
Right Click disabled for Chart only BoondockSaint via OfficeKB.com Charts and Charting in Excel 1 May 3rd 05 10:09 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"