Re: Right Click Pop Up Menus Disabled

Tech-Archive recommends: Fix windows errors by optimizing your registry

In the VBE open the Immediate window, paste this code in and run it:

Commandbars("Cell").Enabled = True

You might want to check the macro that set Enabled to false and inquire why
that was necessary and why it wasn't reset.

--
Jim
"Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0AC4677E-F75B-4DA3-B32E-38050B5CCF77@xxxxxxxxxxxxxxxx
|I forgot to mention the problem only seems to be on the right click for the
| cells. Other right click menus appear to work.
|
| "Steve" wrote:
|
| > My right click pop up menus are disabled. I installed a macro in my
personal
| > workbook with an "Open" event so the menus are there now because of the
| > macro, but something obvioulsy happened to disable them in the first
place.
| > Is there something I can do (other than my personal workbook macro) that
I
| > can do to enable right click menus for the entore Excel application?
| >
| > Thanks for your help
| > Steve


.

Relevant Pages

  • Re: Hot Keys question
    ... If by Tools>Customize and dragging menu items to the worksheet menu bar then ... these customizations are saved in your Excel.XLB file and not with the ... Others won't have access to this *.XLB file so customized menus won't show up. ... >> But I was hoping someone could tell me how i could modify the macro so I ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Right Click Pop Up Menus Disabled
    ... a typo in the sub name Sub Workbook_BeforeClose. ... The beforeclose event was not firing. ... All menus work now without the macro in my personal macro workbook. ...
    (microsoft.public.excel.misc)
  • RE: Shrink to fit Macro Button
    ... Save the macro listed below to your Personal.xls. ... Right click on one of the menus at the top. ... Set rngOriginalRng = Selection ... Post Helpfull to you?''. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Another great example of how Word 2007 "brings commands closer to the surface"
    ... By the same logic by which the menus were eliminated, ... since the "majority" of users don't create custom toolbars and custom menus, ... macro, and never assign a custom keystroke to a macro or to a built-in ... not yet been completely consistent in its program of destruction, ...
    (microsoft.public.word.newusers)
  • Re: Right Click Pop Up Menus Disabled
    ... The beforeclose event was not firing. ... All menus work now without the macro in my personal macro workbook. ...
    (microsoft.public.excel.misc)