I figured it out... at least partly. The beforeclose event was not firing. I
put the same code into a macro triggered by a button click and it worked
fine. All menus work now without the macro in my personal macro workbook. But
now the question is, why didn't the beforeclose macro fire?

"Steve" wrote:

I have that bit of code pasted into my personal workbook on an open event.
I've done it in the immediate window, but it does not enable the menus for
the entire application. And the menus are only enabled as long as that
workbook is open. if I close it and reopen, they are gone (if i take out the
personal workbook macro). is there a setting like in the Tools - Options that
I am missing that turns these off? I did change these settings (in
tools-options) for another workbook, maybe I clicked something that turned
off the pop up menus, too?

"Jim Rech" wrote:

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" wrote in message
...
|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