Zoho Sheet adds VBA support

Zoho has announced update to their “Zoho Sheet”, that now lets you import and create VBA macros in your spreadsheets. At present they support about 50% of the functionality. A full list of what they support is listed here. What about those people who don’t know how to code VBA macros? Unfortunately they don’t have a recording tool, but they say […]

Zoho has announced update to their “Zoho Sheet”, that now lets you import and create VBA macros in your spreadsheets. At present they support about 50% of the functionality. A full list of what they support is listed here.

What about those people who don’t know how to code VBA macros? Unfortunately they don’t have a recording tool, but they say it’s on the way. In the meantime they have setup a Wiki where users can share macros that they have created so that everyone has a chance to benefit from them!

Full features list:

  • Pivot Tables: Pivot tables and pivot charts can be created using a simple drag and drop interface.
  • Support for Named Ranges: Names can now be assigned to a cell or a cell range. These names can then be used in formulas / macros to refer to a range of cells. To define a name, select the cell range and then use the “Name this Cell” menu item in the More Actions menu or in the right click context menu.
  • Multiline Support: Multiline support inside a cell has been added. You can use Ctrl+Enter or Alt+Enter to insert a line break inside a cell.
  • New Publish Options: New publish options have been added to control use of your public spreadsheets in Zoho. You can now restrict users from exporting your public spreadsheet. You can also hide formulas used in your public spreadsheet from your users. This is useful if you want to prevent users from viewing the formulas you have used.