BoostExcel main content

Advanced Sample: Macro-Enabled Invoicing Template

Template#: c5101



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.
1113 KBDownload

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


The screen shot for Advanced Sample: Macro-Enabled Invoicing Template


This sample shows the steps to use ".xlsm" workbooks and templates.

If you are an expert in Microsoft Excel or Microsoft 365, you may want to do more with your template. One of the more advanced ways is to use Excel macros.

To convert an Excel workbook from ".xlsx" to ".xlsm" format, simply use the "File" and "Save As" commands. See How to Use Macros in Excel: 15 Steps (with Pictures) for a sample.

This template is based on the Standard Business Invoicing Template (c5099).

One of the major concerns about using macro-enabled templates is the security settings in Microsoft Excel. If the macro does not have a digital signature with the default security settings, Excel disables it with a warning message.

To overcome this, you have to either lower the security level or sign your macro code.

Format and Specification

Belongs to
Format (XLS or XLSX).xlsm
Line Height (Points)18.00
Print Area$D$3:$K$46
Papaer OrientationPortrait
Default Margins (Points)


Advanced Sample: Invoiced Total in English Words Thumbnail
Advanced Sample: Email Is Required Before Saving Invoice Thumbnail
Advanced Sample: Print One Invoice in Two Different Formats Thumbnail
Standard Business Invoicing Template with Oval Button Thumbnail
Print Shop Bill Sample Thumbnail
Simple Template with Printable Watermark Thumbnail