Buttons in the Invoice Template Don't Work

All invoice templates that work with Excel Invoice Manager, including the standard template installed by default, and the pre-customized templates that can be downloaded from the member area of www.Office-Kit.com, have a group of buttons inside it. It is these buttons that you can click to invoke the functionalities of Excel Invoice Manager.

For example, you click the Save To DB button to save an invoice into the backend database, or click the Customers button to display all customers.

Several users wrote to us complaining that the buttons didn't work or didn't response to the click operations. After digging into the problem, we found out that there were several reasons that could cause the problem.

A. Is Excel Invoice Manager Installed?

If you move or copy an invoice template from one computer to another, but don't install Excel Invoice Manager on the target computer, all buttons in the invoice template won't work. To fix this, just install Excel Invoice Manager on the target computer before moving or coping your (customized) template.

In Excel Invoice Manager, the invoice templates are just pure Excel workbook files. That is, functionalities of Excel Invoice Manager are implemented in the COM-Addin that runs in the background, but not implemented in the template that you can move or copy from one computer to another.

The buttons in the invoice templates are standard ActiveX controls provided by Excel - the only thing they do is receiving the click events and transfer them to the underlying COM-Addin (i.e. Excel Invoice Manager). If you don't install Excel Invoice Manager by running the setup program, the buttons do nothing.

B. Is Excel Invoice Manager Disabled?

Even though Excel Invoice Manager is installed, there are still ways to disable it. To find out whether Excel Invoice Manager is disabled and fix it:

1. Click Excel menu Help -> About Microsoft Office Excel -> Disabled Items.
2. If "Excel Invoice Manager" is listed in the Disabled Items box, then select it and click the Enable button.
3. You need to restart Excel to start Excel Invoice Manager.

C. Is the Invoice Template in Design Mode?

If the invoice template is put in design mode, Excel Invoice Manager won´t response to click operations. This is by design and is a way to let you move, resize and modify the buttons. To make sure the invoice template is not in design mode:

1. Click Excel menu View -> Toolbars, and then check the submenu Control Toolbox to display the Control Toolbox toolbar.
2. Make sure the Design Mode button is not pushed. If it is pushed, click the button to restore it.

   

3. If you want to hide the Control Toolbox toolbar, click Excel menu View -> Toolbars, and then uncheck the submenu Control Toolbox.

For more information about design mode, please see Customizing Invoice Template.

If you cannot exit design mode and see a security warning message, please see Removing Auto-created Macros from Your Invoice Template.

D. File Name with Non-English letters on English Platform

As reported by our user, if you rename the template file with a non-English name, such as containing Croatian letters, but at the same time the Windows system is changed to English which does not support the non-English letters you used in the file name, the template may not be able to response to click events.

To solve the problem, simply rename the template file with English letters.