Assigns macros to program events. The assigned macro runs automatically every time the selected event occurs.
Choose Tools - Customize - Events tab.
The dialogue box has reduced functionality when called from the Edit-Sheet menu of a spreadsheet.
Select first where to save the event binding, in the current document or in Office.
A macro that is saved with a document can only be run when that document is opened.
The big list box lists the events and the assigned macros. After you selected the location in the Save In list box, select an event in the big list box. Then click Assign Macro.
Opens the Macro Selector to assign a macro to the selected event.
Opens the Assign Component dialogue box to set a custom UNO command for the selected event.
Component assignment is proposed for controls in the Dialogue Editor.
Deletes the macro or component assignment for the selected event.