Standard On-sheet Buttons

This document summarizes the button names on the sheet. It also shows how to add the standard buttons to the sheet if you're using a very old version.

If you are using a template that does not have buttons on the sheet, here is how to add them.

• Backup your template.
• Open it as usual.
• Switch to design mode by clicking the "Design Mode" button on the ribbon tab.
• Go to the Excel "Insert" ribbon.
• Click "Text Box" in the "Text" group, and click the location on the sheet where you want to put the button. Excel creates a new text box on the sheet and puts the control in text editing mode.
• Enter the button caption text, such as "Customers".
• Click the corner of the text box. This exits text editing mode and selects the text box itself.
• Go to the "Format" ribbon tab (This tab shows only when the shape object is selected).
• In the "Shape Styles" group, click the "More" down-arrow on the preset style list to show the list of all preset theme fill effects. Choose one of the fill effects you like.
• Name the text box by entering the name in the name box located on the left end of the Excel formula bar. For example, the text box labeled "Customers" should be named "oknCmdCustomer".
• Now right-click the control and choose "Assign Macro".
• Enter the following macro command:

  ExecImeCommand

  Note: You don’t have to create this macro command. It is provided by our invoicing app.

• Repeat the above steps to add all the other buttons. See the table below for button names and captions.
• Once done, exit design mode.
• Save the template.

The following table shows all the button names and captions assigned to each button.