View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Macro as Custom Menu Command

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!