Thread
:
Macro as Custom Menu Command
View Single Post
#
6
Posted to microsoft.public.excel.programming
Trevor Shuttleworth
external usenet poster
Posts: 1,089
Macro as Custom Menu Command
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!
Reply With Quote
Trevor Shuttleworth
View Public Profile
Find all posts by Trevor Shuttleworth