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: 9
Default Custom Menu Item specific to a workbook

Hey guys,
I discovered an old macro at work. It looks like the macro was written as a worksheet, b/c I get the message that macros are now edited in the VBE. When this workbook is opened, a custom menu item(which is assigned to run the macro)appears under 'Tools'. I looked at the code and it only shows code for the macro - nothing about a custom menu item.

How is this menu item being opened? Can I do this with some of my other macros? I know I can put a custom menu item, but it stays there all the time, and it is only on my computer.

Thanks,
TT
 
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
keep new menu item with workbook Andy G. Excel Discussion (Misc queries) 1 May 16th 06 08:09 PM
Excel 2000 Custom Menu Item Larry Bird Excel Discussion (Misc queries) 0 November 8th 05 08:25 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Testing to see if a Workbook menu item exists Todd Huttenstine[_3_] Excel Programming 2 December 31st 03 12:02 AM
Autoload custom menu on Workbook Open Johann[_2_] Excel Programming 1 December 30th 03 07:55 AM


All times are GMT +1. The time now is 08:33 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"