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: 2
Default Making menu item changes temporary

When I add a custom menu item using the Add method I know
I can make it temporary by setting the Temporary property
to True. This is good because I know when my Excel
Application Unloads that is it, they don't show up in
other workbooks.

I need to make some custom changes to Excel Menus (not
custom) though like setting the .OnAction property for
the "EditDelete Sheet" option to point to my own code. I
know how to do this but it affects not only my own
application but also all other spreadsheets that are
opened. I know I can use the Reset method when I close
the application but if for some reason it crashes and the
reset is run there is potential for sheets other sheets to
be affected and passed around and before you know it.....a
mess!!

So how can I make the change temporary to begin with? Is
it possible?

Thanks in advance!
RJ

 
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
windows menu item onzilla Excel Discussion (Misc queries) 1 April 20th 07 06:10 PM
Menu item disabled steven Excel Worksheet Functions 3 July 28th 06 12:59 AM
keep new menu item with workbook Andy G. Excel Discussion (Misc queries) 1 May 16th 06 08:09 PM
How to delete item on right click menu? Bobo Excel Discussion (Misc queries) 1 August 28th 05 04:53 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 05:00 PM.

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"