Tutorial: Adding a Clear button to the Report Worksheets

Starting with Version 2.6 Build 1010, Excel Invoice Manager supports the Clear button added to all the report worksheets. The Clear button allows you to clear the report worksheets manually. If you are using a template customized from the template included in the previous versions of the software, here are the steps to add the Clear button to your existing template.

1. Open your template in Excel and switch to the Sales Report worksheet.
2. By default all the report worksheets are not protected. If you have protected them please unprotect them first. For information about how to do this in Excel, see Customizing the Invoice Template.
3. Switch to design mode. For information about how to do this in Excel, see Customizing the Invoice Template.
4. Click the Print button to select it, press Ctrl+C on your keyboard to copy the button.
5. Press Ctrl+V on your keyboard.
6. Move the pasted button with your mouse, to place it on the same row as other buttons.

   
   (Click to enlarge)

7. Right click the new button and choose Properties from the menu.
8. Enter the name of the command button in the (Name) field on the Properties box. The Clear buttons on different report worksheets must have their own unique name, as detailed in the following table:

   Worksheet name	Name of the Clear button
   Sales Report	oknCmdSalesReportClear
   Customer Report	oknCmdCustomerReportClear
   Product Report	oknCmdProductReportClear
   Customer Statement	oknCmdCustomerStatementClear
   Sales Rep. Report	oknCmdSalesRepReportClear

9. On the same Properties box, enter Clear in the Caption field.

   
   (Click to enlarge)

10. Close the Properties window.
11. Repeat the above steps for each report worksheet. Note: Please name the button according to the above table.
12. Exit design mode. For information about how to do this in Excel, see Customizing the Invoice Template.
13. Save the template.
14. Test.