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
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