Module controls 

Form controls (Insert › Controls): buttons that run a macro or a command, and sliders and spin buttons that hold a whole number from 0 to 30000 and write it to a linked cell.

A slider or spin button’s value lives on the control and in its linked cell. Setting it goes through cell.set, so the cell’s dependents recalculate and Undo takes both back as one step; editing the linked cell moves the control (see [sync_linked_values]). Pressing a button runs its action through the macro policy with the document’s trust, so a button from a file someone else made asks before it runs anything.

Functions

link_target

The cell a link names, from the control’s sheet host: (sheet index, cell). None when it doesn’t name one cell of an existing sheet (a link into a deleted sheet reads #REF!).

specs