Run a Macro from a Menu or a Button on a Sheet
First I think ZOHO Sheets are GREAT ! Your programmers and designers have done a super job !
I think you could greatly expand your potential users if you had a way for your Macros to be Menu driven from the Sheet itself or if you could insert an object with an OnClick event ... which in turn would run a Macro ...
With the addition of that feature complete applications could be built using ZOHO Sheet ... Currently I provide Excel Applications to companies and that is about all I see that would need to be added to ZOHO to be very competitive in that marketplace.
In effect a user designed screen might display Menus such as:
1. Fill out your expense report
2. View your Personal Profile
3. Enter your Job status
Then buy clicking on the particular Menu option ... just as you might click a hyperlink ... the appropriate Macro would execute ... or if those same options could be displayed as Button Labels - and likewise when the button was clicked the Macro assigned to it would execute.
I'd be curious to know if such a features are being talked about ?
Thank you once again for a very nice online spreadsheet .
Rod