"right click" shortcut menu

J

John LaBombard

I have a Windows 2k user that is using Excel 2002
(10.4524.4219)SP-2.
She lost her shortcut menu when she right clicks in a
cell. I have searched around and cannot find a fix for
this. Any help would be much appreciated.

John LaBombard
 
D

David McRitchie

Hi John,
See my http://www.mvps.org/dmcritchie/excel/event.htm

It looks better if you turn off the normal right click menu when doing your own.
Cancel = True 'prevents normal Right-Click menu from appearing

it only applies to the one sheet and only if the event macro is
still there.

If you lost your right click menu on all sheets then use
Application.CommandBars("Cell").Enabled = True

For a macro to reset several things see reset_things in
http://www.mvps.org/dmcritchie/excel/code/proper.txt
 
G

Guest

-----Original Message-----
Hi John,
See my http://www.mvps.org/dmcritchie/excel/event.htm

It looks better if you turn off the normal right click menu when doing your own.
Cancel = True 'prevents normal Right-Click menu from appearing

it only applies to the one sheet and only if the event macro is
still there.

If you lost your right click menu on all sheets then use
Application.CommandBars("Cell").Enabled = True

For a macro to reset several things see reset_things in
http://www.mvps.org/dmcritchie/excel/code/proper.txt

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John LaBombard" <[email protected]>
Click to expand...
wrote in message [email protected]...
.
Click to expand...

It looks like this fix is for a specific sheet. My problem
is that whenever she opens existing or new sheets the
right and the left buttons work the same (no menu). I have
uninstalled\reinstalled Excell on it's own and Office
completely with the same result. I am able to log into the
computer as myself and it works, it looks to be profile
specific. I would like to avoid recreating her profile if
it can be helped. Thanks again for your help.
 
D

David McRitchie

Hi John,
So you are saying that the following line in a normal macro
Application.CommandBars("Cell").Enabled = True 'rclick cell

did not work. Is this just Excel. you might check your
control panel settins for Mouse. Also check for individual
applicaiton overrides on the first tab, if "Enable program specific ..."
is checked than check individual settings from "Settings" button.
 
D

Dave Peterson

Can you try another test?

close excel
windows start button|run
excel /safe
(starts excel in safe mode--avoids code and toolbars)

try out right clicking.

If that worked, close excel and search for *.xlb.
Search through hidden folders and hidden files, too.

Rename any you find to *.xlbOLD.

Then restart excel. If that worked, then dump those *.xlbOLD and recreate your
customized toolbars when you have time.

-----Original Message-----
Hi John,
See my http://www.mvps.org/dmcritchie/excel/event.htm

It looks better if you turn off the normal right click menu when doing your own.
Cancel = True 'prevents normal Right-Click menu from appearing

it only applies to the one sheet and only if the event macro is
still there.

If you lost your right click menu on all sheets then use
Application.CommandBars("Cell").Enabled = True

For a macro to reset several things see reset_things in
http://www.mvps.org/dmcritchie/excel/code/proper.txt

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John LaBombard" <[email protected]>
Click to expand...
wrote in message [email protected]...
.
Click to expand...

It looks like this fix is for a specific sheet. My problem
is that whenever she opens existing or new sheets the
right and the left buttons work the same (no menu). I have
uninstalled\reinstalled Excell on it's own and Office
completely with the same result. I am able to log into the
computer as myself and it works, it looks to be profile
specific. I would like to avoid recreating her profile if
it can be helped. Thanks again for your help.
Click to expand...
 
D

Dave Peterson

I ran this macro:

Option Explicit
Sub testme()
Application.CommandBars("cell").Controls("copy").Enabled = False
End Sub

I rightclicked on a cell and the copy option was disabled.

I closed excel and reopened it (without resetting the toolbar).

The copy option was still greyed out.

I closed excel and dumped my *.xlb file and restarted excel.

I lost all my customizations, but the Copy option was back.

(then I closed excel and copied my backup toolbar file to its rightful spot!!!)

===
I did do this testing after I read your message <bg>, but I think I had tested
this before.

And those customizations have to be stored somewhere.

===

I think the real question is why didn't your suggestion:
Application.CommandBars("Cell").Enabled = True
work.

I would have guessed it would.

But maybe doing both these would make it work:

Application.CommandBars("Cell").reset
Application.CommandBars("Cell").Enabled = True

(but the reset will destroy customizations to just the rightclick menu.)

That, I don't have a theory.

David said:
Hi John,
Be sure to report back what corrected your problem.

If you do dump your Tool Bars file (.XLB), would suggest
that you document what you have so that you can
recreate them later.
http://www.mvps.org/dmcritchie/excel/barhopper.htm

Dave P., any idea why you think Tool Bars might be implicated?
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Dave Peterson said:
Can you try another test?
Click to expand...
Click to expand...
 
Top