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

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

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

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

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

why didn't the beforeclose macro fire?

Should. Unless events are turned off: Application.EnableEvents = False. Or
a typo in the sub name Sub Workbook_BeforeClose.

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