This section describes how to create and assign macros
in IBM® Lotus® Symphony™ Spreadsheets through an
example.
To prompt a "Hello World" message when saving a spreadsheet,
do the following steps:
- Open a spreadsheet and click to
open the Macros window.
- Select the current spreadsheet in the Macro from field
and click New. The New Module window opens.
- Use Module1 as the module name and click OK.
The Basic editor opens.
Tip: In the New Module window,
the default name for the first module is Module1.
You can also enter a new name in the New Module window.
- In the Basic editor, type the following code:
Sub Main
Msgbox "Hello World"
End Sub
- To open the Macros window again, in Lotus Symphony Spreadsheets, click .
- Select Module1 and Main in
corresponding fields and click Assign. The
Customize window opens.
- Select Save Document to assign the macro,
and then click Macro. The Run Macros window
opens.
- In the Run Macros window, select Module1 and Main in
corresponding fields and click OK.
- To run the macro, click OK in the Customize
window and Run in the Macros window.