- Frequently Asked Questions
- What is EditGrid Macro?
- How do I start writing a macro?
- Who can add macro to a spreadsheet?
- Can I write Excel VBA?
- Is it secure? Are there any security concerns?
- Can I share my macros with other workbooks and other users?
What is the difference between Web API, Grid API and Macro API?
Everybody who has write permission to a spreadsheet can add Macros to the spreadsheet.
EditGrid Macro inherits your (write) permissions with the spreadsheet. As a result, you can assume that a macro can do anything to your spreadsheet (which unfortunately includes deleting all the data). As a result, you should only run macros that you write, or are developed by someone who you trust.
Yes. When you first create a macro it resides in the workbook where you created it. In order to share your macro you can publish it to the Macro Library. The Macro Library lists your published macros by default. You can also select "All Macros" to view and install published macros by all EditGrid users.