View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Menus / Links associated with right-mouse-click lost!

Are you writing about the menu that shows up when rightclick in a cell--there
are lots of things you can rightclick on.

If it's just the cell rightclick menu:
Open excel
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
application.commandbars("cell").enabled = true
and then type this and hit enter
application.commandbars("cell").reset

And then back to excel to test it out.



adnessoz wrote:

I've lost the ability to use my right-mouse click to bring up menus and
associated links in Excel (only - other office programs still support this
ability eg. Word/PPT still ok). This came about after I was using a
spreadsheet which had macros I believe associated with the right mouse click.
I've checked my macros in Excel and currently have nothing associated with
this saved and am at a loss as to how I get the use of my right mouse click
back.


--

Dave Peterson