Macros

Product: MyOffice Professional, MyOffice Private Cloud

Application: Spreadsheet Web version

Macros are small programs allowing to automate lengthy or time-consuming tasks in spreadsheets. Macros in MyOffice Spreadsheet are written using Lua programming language.

Macros are usually used for the following purposes:

•Adding text

•Find and replace throughout the text

•Delete text

In the web version, you can only run macros. To create, edit or delete macros, use the desktop version of MyOffice applications.

If there are macros in the document, the Run macro command will be displayed on the Tools command menu, which provides access to the list of macros in the document.

During the execution of a macro, working with the document is blocked by the message about the execution.

If the execution fails for some reason (such as an error in the macro itself), an error message will be displayed.

Running and executing VBA macros in MyOffice Spreadsheet is not supported. After converting an .xlsm file format into the internal format, the macros will be displayed in the Tools > Run macro command menu, but cannot be executed.

Was this helpful?

Yes