We have been supporting VBA macros for the pastthreeyears in Zoho Sheet. Last month we made a significant revamp of our Macro execution engine. With this update, your macros could run faster by up to 75% than before depending on what your macro does.
Here is a spreadsheet which generates Vicsek fractal (box fractal) using macros. There are 4 different fractals generated in 4 different worksheets. Click on the 'Generate Fractal' button in each worksheet to generate different fractals. To change the number of iterations, press the 'Click to Edit' button, change the iterations in the white box and then generate the fractal again.
We now support referring to a Sheet module by its CodeName. Each worksheet is given a unique CodeName which will not change even if the worksheet is moved around or renamed. You can see the CodeName in the Spreadsheet Objects Explorer tree, when you open the VBA Editor (Alt+F11). You can invoke functions in other sheet modules by using its CodeName. So your macro code won't change when you rename your worksheets.
Going forward we will add more features to our Macros functionality such as User Defined Functions, initiating HTTP requests, and more. Let us know what features in Macros, you would like to see in Zoho Sheet.