Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Designed for vacuum repair shop, this template implements two print buttons - "print with claim" and "Print no claim". Both print the same invoice but the first button attaches a "claim" portion to the bottom of the invoice.
The default "Print" button included many templates here on InvoicingTemplae.com print the whole "Invoice" worksheet. This in fact prints the Excel range defined by the "Print_Area" name. There are many ways you can customize the print behavior, as shown on the samples at printable invoice templates.
In this sample, the vacuum repairer want to include the following claim on the initial invoice:
REPAIR POLICY --- PLEASE READ!
By leaving your repair, you accept and agree to this policy.
A $10.50 ESTIMATE FEE APPLIES TO ALL VACUUMS
MUST BE PICKED UP WITHIN SEVEN DAYS OF COMPLETION
AFTER 14 DAYS A $1.00 PER DAY FEE WILL ACCRUE.
REPAIRS LEFT OVER 30 DAYS WILL BE SOLD FOR CHARGES.
ESTIMATE FEES ARE POSTED AND ADHERED TO.
And on the final invoice, the claim is removed.
In this advanced sample, we implemented this by adding two new "print" buttons, as shown on the screenshots where they have green and blue background color.
The following section describes briefly the steps involved to create the buttons. This should help you understand how they works.
- First, save your invoice template in ".xlsm" format by using Excel's "File" / "Save As" command. The ".xlsm" format enables the Excel template to include VBA macro code.
- Switch to "Design Mode" button by pushing down the "Design Mode" button on the "Invoice" ribbon tab.
- Click to select the "Print" button (be sure to click the border of the button, otherwise will be activating the text box instead of selecting the entire shape object).
- Hit "Del" key on keyboard to delete the button.
- Go to Excel ribbon "Insert", pull down the "Shapes" list in the "Illustrations" group, choose the "Rectangle" shape from list.
- Click the location where you want to put your first new print button.
- Enter the button caption "Print w/ claim".
- Go to Excel ribbon tab "Format", and then expand the predefined shape styles from the "Shape Styles" group by clicking the "down arrow" icon, choose one of the style you like -- in this case, we choose the green background style with white foreground color.
- Name the button "btnInitial" by entering the name into the name box located on left corner of the formula bar.
- Right-click the button and choose "Assign Macro" from the shortcut menu.
- On the "Assign Macro" dialog box, choose "New".
- Excel opens the macro editor and creates an empty macro like this:
Public Sub btnPrintWithClaim_Click() End Sub
- Fill code into the VBA procedure so that it looks like this:
Public Sub btnPrintWithClaim_Click() Range("rgnInitial").PrintOut End Sub
The "On Error Resume Next" statement hides additional error messages when printing is not successful. Because Windows usually display such error message by itself - for example, if a user cancels a print job, so it is safe to hide macro error message here.
- Repeat the above step to create the second button. This time the button caption is "Print No Claim", the button name is "btnPrintFinal", the macro code for the button looks like this:
Public Sub btnPrintNoClaim_Click() Range("rgnFinal").PrintOut End Sub
- Save the template by clicking Excel menu "File" and then "Save".
The VBA macro code reference to two named range "rngInitial" and "rngFinal". When a button is clicked, the named range on the worksheet is printed out. The range "rngInitial" covers the entire central section on the "invoice" worksheet, including the "Claim" section. The range "rngFinal" does not include the "Claim" section. This allows us to print the same invoice with two different formats or form layouts.
Format and Specification
|Name||Advanced Sample - Print One Invoice in Two Different Formats|
|Category||Service Invoice Template|
|Release Date||Monday, October 22, 2018|
|Format (XLS or XLSX)||.xlsm|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|