ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   the right button of mouse cant do nothing (https://www.excelbanter.com/excel-discussion-misc-queries/42969-right-button-mouse-cant-do-nothing.html)

rapidito78840

the right button of mouse cant do nothing
 

Please anybody can tellme why when I point on any cell of any excel
file, and try to do one click with my right button on my mouse, dont
showme the options ?
because my right button dont do nothing, and if I want to format any
specific cell, I need to go to "Format" and then the options on the
menu bar...

In the past this option its working very well, but today its gone !!

can any body tellme what its happening ? ( my mouse its working good in
other programs or on windows )

thanks
:rolleyes:


--
rapidito78840
------------------------------------------------------------------------
rapidito78840's Profile: http://www.excelforum.com/member.php...o&userid=26326
View this thread: http://www.excelforum.com/showthread...hreadid=400317


Dave Peterson

Since the right click works in other applications, then it's probably not the
mouse.

If you add a new worksheet, does it work ok there?
If you add a new workbook, does it work ok there?

A developer could have disabled the rightclick for that worksheet, that
workbook, or even excel itself.

If you start excel in safe mode:
close excel
windows start button|Run
excel /safe

and test your right click.

If it works ok there, you could close excel and try this:

restart excel normally
hit alt-f11 (to get to the vbe)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.commandbars("Cell").enabled = true

Then back to excel and test it.

If it still doesn't work, back to the VBE immediate window and type this and hit
enter:
application.commandbars("Cell").reset



rapidito78840 wrote:

Please anybody can tellme why when I point on any cell of any excel
file, and try to do one click with my right button on my mouse, dont
showme the options ?
because my right button dont do nothing, and if I want to format any
specific cell, I need to go to "Format" and then the options on the
menu bar...

In the past this option its working very well, but today its gone !!

can any body tellme what its happening ? ( my mouse its working good in
other programs or on windows )

thanks
:rolleyes:

--
rapidito78840
------------------------------------------------------------------------
rapidito78840's Profile: http://www.excelforum.com/member.php...o&userid=26326
View this thread: http://www.excelforum.com/showthread...hreadid=400317


--

Dave Peterson

rapidito78840


If you add a new worksheet, does it work ok there? NO
If you add a new workbook, does it work ok there? NO



If you start excel in safe mode:
close excel
windows start button|Run
excel /safe ON THIS I DONT KNOW HOW TO DO THIS ..SORRY !!



Restart excel normally
hit alt-f11 (to get to the vbe)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.commandbars("Cell").enabled = true I DO THIS AND NOW MY EXCEL WORKS VERY GOOD.... THANKS,


I THINK maybe one code of VBA disabled this option but in everything
file what I open I check if that file have any code of VBA and the file
dont have any code and however my rightclick on the mouse still
disabled....

but now its working very well...


thanks... thanks.... thanks.....

:) :) :)


--
rapidito78840
------------------------------------------------------------------------
rapidito78840's Profile: http://www.excelforum.com/member.php...o&userid=26326
View this thread: http://www.excelforum.com/showthread...hreadid=400317


Dave Peterson

Glad you got it working.

But to start excel in safe mode, just:
click on the windows start button (bottom left usually)
select Run
type:
Excel /safe

And your there.

And if it happens again, you may want to use the techniques described here to
isolate the problem:

Chip Pearson's:
http://www.cpearson.com/excel/StartupErrors.htm

Jan Karel Pieterse's:
http://www.jkp-ads.com/Articles/StartupProblems.htm


rapidito78840 wrote:

If you add a new worksheet, does it work ok there? NO
If you add a new workbook, does it work ok there? NO


If you start excel in safe mode:
close excel
windows start button|Run
excel /safe ON THIS I DONT KNOW HOW TO DO THIS ..SORRY !!


Restart excel normally
hit alt-f11 (to get to the vbe)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.commandbars("Cell").enabled = true I DO THIS AND NOW MY EXCEL WORKS VERY GOOD.... THANKS,


I THINK maybe one code of VBA disabled this option but in everything
file what I open I check if that file have any code of VBA and the file
dont have any code and however my rightclick on the mouse still
disabled....

but now its working very well...

thanks... thanks.... thanks.....

:) :) :)

--
rapidito78840
------------------------------------------------------------------------
rapidito78840's Profile: http://www.excelforum.com/member.php...o&userid=26326
View this thread: http://www.excelforum.com/showthread...hreadid=400317


--

Dave Peterson


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com