PDA

View Full Version : Solved: Can OnAction call an event



stanl
07-22-2006, 07:07 AM
The scenario is you are creating a temporary right-click menu option cBut



cBut.Caption = "New Option"
cBut.Style = msoButtonCaption
cBut.OnAction = "My_Macro"


Can "My_Macro" be changed to an event, i.e. cBut.OnAction = "Calculate()"

Stan

stanl
07-22-2006, 12:09 PM
Scratch that thought - easier to disable the context menu and display my own custom-menu which I can control.:hide: Stan