Skip to main content link. Accesskey S
  • Anonymous
  • Log on
  • Help
  • IBM logo
  • Lotus Symphony wiki
  • All Wikis
  • Home
  • Community Articles
  • Product Documentation
  • Learning Center


Search

Advanced Search

Categories

Tag Cloud

  • 1.2
  • 1.3
  • 3.0
  • 3.0.1
  • accessibility
  • aligning
  • AutoCorrect function
  • axes
  • basics
  • best practices
  • calculating
  • cell formatting
  • Cell ranges
  • cells
  • charts
  • color
  • conditional formatting
  • controls
  • converting
  • courses
  • dates
  • deleting
  • Development
  • Direct cursor
  • document
  • documents
  • drag and drop
  • draw objects
  • Duplicate formatting
  • editing
  • fields
  • fonts
  • footers
  • form controls: toolbar
  • Format
  • Format Painter. See Duplicate formatting.
  • formats
  • formatting
  • formula bar
  • formulas
  • Gallery
  • getting started
  • graphic
  • guides
  • Header
  • headers
  • headings
  • Help
  • how do i
  • hyperlinks
  • indexes
  • inserting
  • keyboard
  • learning
  • lotus
  • lotus symphony
  • Macro
  • macros
  • Navigator
  • Notes
  • numbering
  • numbers
  • objects
  • office
  • opening
  • page styles
  • pages
  • power user
  • presentation
  • presentations
  • printing
  • properties
  • reference card
  • revisions
  • rows
  • saving
  • sections
  • selecting
  • selection lists
  • sheets
  • sidebar
  • slides
  • spellcheck
  • Spreadsheet
  • spreadsheets
  • styles
  • Symphony
  • table
  • tables
  • templates
  • text
  • Tips and Tricks
  • toolbars
  • tutorial
  • validity
  • versions
  • video3
  • videos
  • Widget
  • zooming
InformationInformation
You are currently viewing machine translated content. IBM translation might be available. Click IBM Translated Product Documentation to see what is available.X


Home > Macros > A "Hello World" sample of Symphony macro
Rate this article 1 starRate this article 2 starsRate this article 3 starsRate this article 4 starsRate this article 5 stars

A "Hello World" sample of Symphony macro 

expanded Abstract
collapsed Abstract
A sample to show how to create macros in Symphony
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.

expanded Article information
collapsed Article information
Category:
Macros
Tags:
macro

This Version: Version 1 December 15, 2010 4:45:03 AM by Chen CDL Liu  IBMer

expanded Attachments (0)
collapsed Attachments (0)

 


expanded Versions (1)
collapsed Versions (1)
Version Comparison     
Version Date Changed by               Summary of changes
This version (1) Dec 15, 2010 4:45:03 AM Chen CDL Liu  
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 ConnectedSubscribe to RSSHelpAbout
  • All Lotus and WebSphere Portal wikis
  • IBM developerWorks
  • IBM Software support
  • IBM Social Business User Experience Blog
  • IBMSocialBizUX on Twitter
  • IBMSocialBizUX on Facebook
  • Lotus product forums
  • IBM Social Business UX blog
  • IBM Collaboration Solutions
  • Recently added feedRecently added
  • Recently edited feedRecently edited
  • Recently added comments feedRecently Added Comments
  • Wiki Help
  • Forgot user name/password
  • Wiki design feedback
  • Content feedback
  • About the wiki
  • About IBM
  • Privacy
  • Contact IBM
  • IBM Terms of use
  • Wiki terms of use