the right button of mouse cant do nothing

[rapidito78840]

Please anybody can tellme why when I point on any cell of any exce
file, and try to do one click with my right button on my mouse, don
showme the options ?
because my right button dont do nothing, and if I want to format an
specific cell, I need to go to "Format" and then the options on th
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 i
other programs or on windows )

thanks
:rolleyes

 

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

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 everythin
file what I open I check if that file have any code of VBA and the fil
dont have any code and however my rightclick on the mouse stil
disabled....

but now its working very well...


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

:

 

[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