View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_4_] Glen Mettler[_4_] is offline
external usenet poster
 
Posts: 70
Default User defined menu

I have a user defined menu. Most of the main options have sub-options. I
want to make the caption of one of the sub-options dynamic so that it
changes based on a value. In this case I need to toggle EnableEvents on and
off. The sub-menu option of "Utilities" is "Events Enabled" (or "Events
Disabled").

I already have a macro to enable/disable the Events. What I need now is a
way to dynamically change the caption on the sub-menu. so that it reads
"Events Enabled" or "Events Disabled" as the case may be.

Is that possible?

Glen