Skip to main content
office-kit.com main content

Adding or Removing the 'Same As Bill To' Button

- Document for Excel Invoice Manager

 Share This Page

This version of the document, "Adding or Removing the 'Same As Bill To' Button", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.

Starting with Version 2.9.1013, Excel Invoice Manager adds a new button "Same As Bill To" to the Invoice worksheet of the standard invoice template. As the name implies, the button copies the address information from the Bill To section to the Ship To section, so that you don't need to enter the same information again.

Adding the "Same As Bill To" Button

For users who desire to use the existing template with the new version of Excel Invoice Manager program, the following tutorial demonstrates how to add the Same As Bill To button to the invoice template shipped with the previous versions of Excel Invoice Manager.

Tip: Make sure you have installed the latest version of Excel Invoice Manager before you begin.

  1. Open your invoice template.
  2. Unprotect the Invoice worksheet. (How?)
  3. Switch to design mode. (How?)
  4. Display row/column headers and gridlines. (How?)
  5. Right-click the View Customer Info button, and choose Copy from the menu.

    same as Bill To button - create the button

  6. Right-click cell L15 (or any empty area near the Ship To section), and then choose Paste from the menu. A new button is created (pasted).

    same as Bill To button - paste button

  7. Right-click the newly created button, choose Properties from the menu. The Properties box appears.

    same as Bill To button - figure 3: Properties box 1

  8. In the Name field, enter "oknCmdSameAsBillTo"; In the Caption field, enter "Same As Bill To", as the figure below.

    same as Bill To button - figure 4: Fill in Properties box

  9. Close the Properties box.
  10. Hide gridlines and row/column headers.
  11. Exit design mode. Protect the Invoice worksheet.
  12. Save the template.

Now if you click the newly created Same As Bill To button, the address information in the Bill To section will be copied to the Ship To section.

Removing the "Same As Bill To" Button

  1. Open your invoice template.
  2. Unprotect the Invoice worksheet. (How?)
  3. Switch to design mode. (How?)
  4. Click the "Same As Bill To" button to select it.
  5. Hit DEL key on your keyboard.
  6. Exit design mode.
  7. Protect the Invoice worksheet.
  8. Save the template.