I've inherited a spreadsheet with two commands in the tools menu that used
to run macros, but no longer work because the underlying macros have either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is open, and do
not linger when the file is closed.

Where do these additional menu commands live? I need to access them to
edit/delete them, but can't find them. I don't see a module for them; the
macros have no (apparent) reference to a menu command; when I edit the menu
using tools..customize and right clicking on the menu item, I can fix the
commands, but when I leave excel and return, my changes are lost (this leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

Clint

have you looked in the ThisWorkbook class module ? This would likely
contain the code which runs when the workbook is opened and any subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu that used
to run macros, but no longer work because the underlying macros have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is open, and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access them to
edit/delete them, but can't find them. I don't see a module for them; the
macros have no (apparent) reference to a menu command; when I edit the
menu
using tools..customize and right clicking on the menu item, I can fix the
commands, but when I leave excel and return, my changes are lost (this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

Hi Trevor!
There's nothing in the "This Workbook" class module. Any other thoughts?


"Trevor Shuttleworth" wrote in message
...
Clint

have you looked in the ThisWorkbook class module ? This would likely
contain the code which runs when the workbook is opened and any
subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu that
used
to run macros, but no longer work because the underlying macros have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is open,
and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access them to
edit/delete them, but can't find them. I don't see a module for them;
the
macros have no (apparent) reference to a menu command; when I edit the
menu
using tools..customize and right clicking on the menu item, I can fix
the
commands, but when I leave excel and return, my changes are lost (this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

Check the regular code modules for macros named Auto_Open and
Auto_Close.

In article ,
"Clint Marshall" wrote:

Hi Trevor!
There's nothing in the "This Workbook" class module. Any other thoughts?


"Trevor Shuttleworth" wrote in message
...
Clint

have you looked in the ThisWorkbook class module ? This would likely
contain the code which runs when the workbook is opened and any
subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu that
used
to run macros, but no longer work because the underlying macros have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is open,
and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access them to
edit/delete them, but can't find them. I don't see a module for them;
the
macros have no (apparent) reference to a menu command; when I edit the
menu
using tools..customize and right clicking on the menu item, I can fix
the
commands, but when I leave excel and return, my changes are lost (this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

There are no macros or modules at all besides the one macro that I'm trying
to get the menu command to properly access.


"J.E. McGimpsey" wrote in message
...
Check the regular code modules for macros named Auto_Open and
Auto_Close.

In article ,
"Clint Marshall" wrote:

Hi Trevor!
There's nothing in the "This Workbook" class module. Any other
thoughts?


"Trevor Shuttleworth" wrote in message
...
Clint

have you looked in the ThisWorkbook class module ? This would likely
contain the code which runs when the workbook is opened and any
subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu
that
used
to run macros, but no longer work because the underlying macros have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is
open,
and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access them
to
edit/delete them, but can't find them. I don't see a module for
them;
the
macros have no (apparent) reference to a menu command; when I edit
the
menu
using tools..customize and right clicking on the menu item, I can
fix
the
commands, but when I leave excel and return, my changes are lost
(this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

Clint

send me the workbook and I will try to find out what is happening



Regards

Trevor


"Clint Marshall" wrote in message
...
There are no macros or modules at all besides the one macro that I'm
trying
to get the menu command to properly access.


"J.E. McGimpsey" wrote in message
...
Check the regular code modules for macros named Auto_Open and
Auto_Close.

In article ,
"Clint Marshall" wrote:

Hi Trevor!
There's nothing in the "This Workbook" class module. Any other
thoughts?


"Trevor Shuttleworth" wrote in message
...
Clint

have you looked in the ThisWorkbook class module ? This would
likely
contain the code which runs when the workbook is opened and any
subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu
that
used
to run macros, but no longer work because the underlying macros
have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is
open,
and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access
them
to
edit/delete them, but can't find them. I don't see a module for
them;
the
macros have no (apparent) reference to a menu command; when I edit
the
menu
using tools..customize and right clicking on the menu item, I can
fix
the
commands, but when I leave excel and return, my changes are lost
(this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!

Clint

send me the workbook and I will try to find out what is happening



Regards

Trevor


"Clint Marshall" wrote in message
...
There are no macros or modules at all besides the one macro that I'm
trying
to get the menu command to properly access.


"J.E. McGimpsey" wrote in message
...
Check the regular code modules for macros named Auto_Open and
Auto_Close.

In article ,
"Clint Marshall" wrote:

Hi Trevor!
There's nothing in the "This Workbook" class module. Any other
thoughts?


"Trevor Shuttleworth" wrote in message
...
Clint

have you looked in the ThisWorkbook class module ? This would
likely
contain the code which runs when the workbook is opened and any
subroutines
used to add and delete the toolbar entries.

Regards

Trevor


"Clint Marshall" wrote in message
...
I've inherited a spreadsheet with two commands in the tools menu
that
used
to run macros, but no longer work because the underlying macros
have
either
had their names changed or been deleted.

These menu commands only appear when the specific excel file is
open,
and
do
not linger when the file is closed.

Where do these additional menu commands live? I need to access
them
to
edit/delete them, but can't find them. I don't see a module for
them;
the
macros have no (apparent) reference to a menu command; when I edit
the
menu
using tools..customize and right clicking on the menu item, I can
fix
the
commands, but when I leave excel and return, my changes are lost
(this
leads
me to believe they're being controlled from somewhere else).

Thank you for your help in tracking these down!