UniformSoftware main content

Standard On-sheet Buttons

Template#: c5094

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
425 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Standard On-sheet Buttons

Detail

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.

#CommandName
1Clear & NewoknCmdClear
2Save To DB (Save Invoice)oknCmdSave
3Extract / EmailoknCmdExtract
4PrintoknCmdPrint
5PaymentoknCmdPayment
6DetailoknCmdDetail
7CustomersoknCmdCustomer
8ProductsoknCmdProduct
9InvoicesoknCmdInvoice
10ReportoknCmdReport
11SettingsoknCmdSettings
12HelpoknCmdHelp
13As As New CustomeroknCmdSaveAsNewCustomer
14Customer EditoknCmdCustomerEdit
15About / RegistrationoknCmdAbout
16Same As Bill TooknCmdSameAsBillTo
17Pick Customer 
18Pick Shipping Address 
19Pick Sales Rep. Name 
20Pick "Ship Via" / Shipping Method 
21Pick Payment Term 
22Pick Product / Item 

Format and Specification

Template#c5094
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree