the right button of mouse cant do nothing

[rapidito78840]

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

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

[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