LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Macro as Custom Menu Command

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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Menu with Macro doesn't save. Brijesh Excel Discussion (Misc queries) 2 December 12th 07 11:35 PM
Assign macro name to menu command w/o using workbook name Blight_Pete Excel Discussion (Misc queries) 0 August 3rd 06 10:48 PM
Name command in Insert Menu Ahmad Wali Zahid Excel Discussion (Misc queries) 1 January 31st 06 08:37 AM
How do I add a macro to a custom menu? MikeCyng Excel Discussion (Misc queries) 6 October 24th 05 02:56 PM
there is no XML command on my data menu Mattie Excel Worksheet Functions 1 November 27th 04 09:00 AM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"