image

To turn on the Developers tab, go to the Office Button → Excel Options
→ Select Show Developer tab in the Ribbon → OK.

To use buttons in Excel templates, you must first access visual basic and turn on the
FPMXLClient via Tools → References

Custom VBA Functions – Event Based
You can customize your VBA code by associating the events listed below. You can use
these custom functions when you build Visual Basic for Applications (VBA) modules.
• BEFORE_CONTEXTCHANGE – Use this function to execute a custom operation
before changing the context.
• AFTER_CONTEXTCHANGE – Use this function to execute a custom operation
after changing the context.
• BEFORE_REFRESH – Use this function to execute a custom operation before
the system refreshes the data.
• AFTER_REFRESH – Use this function to execute a custom operation after the
system refreshes the data.
• BEFORE_SAVE – Use this function to execute a custom operation before the
system saves data into the database.
• AFTER_SAVE – Use this function to execute a custom operation after the system
saves data into the database. The return values to use for all these events are:
true or false.