FAQ
Vanliga frågor för självhjälp.
Ta en snabb titt på vanliga frågor (och svar) i standardlistan. Om du inte hittar det du letar efter, börja med att välja din Ability Office version och sedan begränsa den genom att ange söktext och/eller kategori.
Kunskapsbasartikel 101
Run macros from HyperlinksA neat way to provide the "glue" that links documents to macro code, macros can be run using the hyperlink function.
Example using Spreadsheet
- Create simple macro - select Tools/Macro/Macros
- In the Macro name box, type TestMacro and click Create
- Below the line "Sub TestMacro", enter:
MsgBox "Hello" - Use the Windows menu to return to the spreadsheet
- In a spare cell, type:
=Hyperlink("#TestMacro", "Click here")
NB: You don't have to put in Click here - any description will do.
Now you can click the hyperlink "Click Here" to run the macro - a simple message box will appear.
The hash symbol (#) above is used to denote a macro (as opposed to a normal URL). The macro in this case is an Application level macro and is available for any Spreadsheet. It's also possible to run a macro in a document. In this case, the syntax is:
=HYPERLINK("documentname#macroname", "Click here")
For example, a user called Phil, with a macro called "startit" in a spreadsheet called myspread stored in my documents would enter:
=HYPERLINK("C:\Documents and Settings\Phil\My Documents\myspread.aws#startit", "Click here")
The HYPERLINK function can be used in a similar way in Write (use Insert/Hyperlink) and Database (create a calculated
field to hold the function - see Knowledge Base Article 82: Creating a database of hyperlinks for an example).