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
|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
| > > | > > |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
| > >
| > >
| > >
