Skip to main content link. Accesskey S
  • Log In
  • Help
  • IBM Logo
  • Lotus Symphony wiki
  • All Wikis
  • All Forums
  • Home
  • Product Documentation
  • Community Articles
  • Learning Center
  • IBM Redbooks
Community Articles Product Documentation Learning Center IBM Redbooks This category Lotus Symphony 3 Documentation Custom Search Scope...
Search
Community Articles > Macros > A "Hello World" sample of Symphony macro
  • New Article
  • Share Show Menu▼
  • Subscribe Show Menu▼

About the Original Author

IBM contributorChen CDL Liu
Contribution Summary:
  • Articles authored: 2
  • Articles edited: 0
  • Comments Posted: 0

Recent articles by this author

A "Hello World" sample of Symphony macro

A sample to show how to create macros in Symphony

Change macro security settings in Symphony

How to change the macro security settings to control under what circumstances macros can be run when you open a spreadsheet

Community articleA "Hello World" sample of Symphony macro

Added by IBM contributor Chen CDL Liu on December 15, 2010 | Version 1
  • Edit
  • More Actions Show Menu▼
Rate this article 1 starsRate this article 2 starsRate this article 3 starsRate this article 4 starsRate this article 5 stars
expanded Abstract
collapsed Abstract
A sample to show how to create macros in Symphony
Tags: macro
In this article we will create a simple "Hello World" sample to show how to create macros in Symphony. Taking the following steps, we create a Symphony spreadsheet which will pop up a "Hello World" dialog whenever we save the document.



1. Open a new Symphony spreadsheet document.

2. Use Tools -> Macros -> Macros... to open the Macros dialog.

3. On the left hand of the dialog, find the newly opened document. Single click it. Then click the "New" button on the right to create a new module.


4. In the following dialog, you can choose to use the default name "Module1" or assign another name to the new module. Here we choose to use the default name.


5. In the opened Symphony Macro IDE window, type the code as follows:


6. Open the Macros dialog. Click the "Assign" button on the right


7. In the opened Customize dialog, choose an event to assign our macro code. Here we choose the "Save Document" event.


8. In the opened Run Macros dialog, choose the macro that we created.


9. Here we finish. Every time we save this spreadsheet, a "Hello World" dialog will pop up automatically.

  • Edit
  • More Actions Show Menu▼


expanded Attachments (0)
collapsed Attachments (0)
Edit the article to add or modify attachments.
expanded Versions (1)
collapsed Versions (1)
Version Comparison     
VersionDateChanged by              Summary of changes
This version (1)Dec 15, 2010 4:45:03 AMChen CDL Liu  IBM contributor
expanded Comments (0)
collapsed Comments (0)
Copy and paste this wiki markup to link to this article from another article in this wiki.
Go ElsewhereStay ConnectedHelpAbout
  • IBM Collaboration Solutions wikis
  • IBM developerWorks
  • IBM Software support
  • Twitter LinkIBMSocialBizUX on Twitter
  • FacebookIBMSocialBizUX on Facebook
  • ForumsLotus product forums
  • BlogsIBM Social Business UX blog
  • Community LinkIBM Collaboration Solutions
  • Wiki Help
  • Forgot user name/password
  • Wiki design feedback
  • Content feedback
  • About the wiki
  • About IBM
  • Privacy
  • Accessibility
  • IBM Terms of use
  • Wiki terms of use