Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Office Basic Macros

Opens a dialogue box to organise macros.

To access this command...

Choose Tools - Macros - Organize Macros - Office Basic, or press Alt+F11 (if not assigned by your system).

Macro name

Displays the name of the selected macro. To create or to change the name of a macro, enter a name here.

Macro from / Save macro in

Lists the libraries and the modules where you can open or save your macros. To save a macro with a particular document, open the document, and then open this dialogue box.

Run / Save

Runs or saves the current macro.

Assign

Opens the Customise dialogue box, where you can assign the selected macro to a menu command, a toolbar, or an event.

Edit

Starts the Office Basic editor and opens the selected macro or dialog for editing.

New / Delete

Creates a new macro, creates a new module or deletes the selected macro or selected module.

To create a new macro in your document, select the "Standard" module in the Macro from list, and then click New.

To create a new module in a library of the My Macros container, select the proper library and press New. The Office Basic editor opens.

To delete a macro or module, select it, and then click Delete.

New Library

Saves the recorded macro in a new library.

New Module

Saves the recorded macro in a new module.

Organiser

Opens the Macro Organiser dialogue box, where you can add, edit, or delete existing macro modules, dialogue boxes, and libraries.