Zoho Sheet: Macros - Record & Playback


We recently launched Macros (and Pivot Tables) support in Zoho Sheet. With our recent update, we are now extending this further with support for recording and playback of Visual Basic Macros.

While writing Macros from scratch requires knowledge of Visual Basic, recording Macros just needs couple of clicks. Under the Macros Menu, you'll now see the 'Record Macro' option to start the record process.

After you start recording, all the changes you make to the spreadsheet will be recorded and the appropriate Visual Basic code will be created at the back-end for you. Once you are done recording the Macro, you can view the code and apply that Macro to other Sheets.

This video shows this functionality in action.





At Zoho, we have been focusing more on business side of things rather than the consumer side. You'll notice this on our home page where half the applications are business focused. Apart from business focused apps (like CRM, HR, Invoicing, Project Management etc) we are also extending this business focus to the individual applications by adding business friendly functionality like Macros.

Breadth (of applications) and Depth (in functionality) is what we are aiming for. This update certainly falls into the Depth category.