IBM Lotus Symphony


Creating and assigning macros

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:
  1. Open a spreadsheet and click Tools > Macros > Macros to open the Macros window.
  2. Select the current spreadsheet in the Macro from field and click New. The New Module window opens.
  3. 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.
  4. In the Basic editor, type the following code:
    Sub Main
    	Msgbox "Hello World"
    End Sub
  5. To open the Macros window again, in Lotus Symphony Spreadsheets, click Tools > Macros > Macros.
  6. Select Module1 and Main in corresponding fields and click Assign. The Customize window opens.
  7. Select Save Document to assign the macro, and then click Macro. The Run Macros window opens.
  8. In the Run Macros window, select Module1 and Main in corresponding fields and click OK.
  9. To run the macro, click OK in the Customize window and Run in the Macros window.

Product Feedback | Additional Documentation | Trademarks