Skip to main content
office-kit.com main content

Buttons in the Invoice Template Don't Work

All invoice templates that work with Uniform Invoice Software (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 Uniform Invoice Software (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 Uniform Invoice Software (Excel Invoice Manager) Installed?

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

In Uniform Invoice Software (Excel Invoice Manager), the invoice templates are just pure Excel workbook files. That is, functionalities of Uniform Invoice Software (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. Uniform Invoice Software (Excel Invoice Manager)). If you don't install Uniform Invoice Software (Excel Invoice Manager) by running the setup program, the buttons do nothing.

B. Is Uniform Invoice Software (Excel Invoice Manager) Disabled?

Even though Uniform Invoice Software (Excel Invoice Manager) is installed, there are still ways to disable it. To find out whether Uniform Invoice Software (Excel Invoice Manager) is disabled and fix it on Excel 2000/XP/2003:

  1. Click Excel menu Help -> About Microsoft Office Excel -> Disabled Items.
  2. If "Uniform Invoice Software (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 Uniform Invoice Software (Excel Invoice Manager).

On Excel 2007/2010/2013:

  1. Click Office button -> Excel Options if you are running Excel 2007; or click File -> Options if you are running Excel 2010/2013.
  2. Click Add-ins on the left command bar.
  3. Choose Disabled Items from the Manage list. Click Go.
  4. If Uniform Invoice Software (Excel Invoice Manager) is listed as a disabled item, click it and then enable it by clicking the Enable button.
  5. Restart Excel.

C. Is the Invoice Template in Design Mode?

If the invoice template is put in design mode, Uniform Invoice Software (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. Is the Program Corrupt?

The program files could be corrupt because of a virus or other threatening program. You can verify the digital signature of the program files to quickly find out if they are intact. To do this:

  1. Open Uniform Invoice Software (Excel Invoice Manager) installation folder in Windows Explorer. By default the installation folder of Excel Invoice Manager is:

    <System Driver>\Program Files\Office-Kit.com\Uniform Invoice Software (Excel Invoice Manager)\

    And, the default installation folder for Uniform Invoice Software is:

    <System Driver>\Program Files\Uniform Software\Uniform Invoice Software

  2. For Excel Invoice Manager, there are two executable files, OKINVMAN.dll and OKINVCTL.ocx. Right-click one of the files, choose Properties.

    For Uniform Invoice Software, check UISMAINM.DLL.

  3. Open the Digital Signature tab.
  4. Click to select Uniform Software Ltd or Lantian Software Studio digital signature and then click Details.
  5. The Digital Signature Details dialog box should display a message "This digital signature is OK". If you don´t see this message, the file you are verifying is corrupt.

If you find one or both of the executable files are corrupt, the first thing you need to do is to install a virus scanner and then scan your whole system completely. Once you are sure that your system is clean, then re-download and install Uniform Invoice Software (Excel Invoice Manager).

E. 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.

F. Security Settings

The default security setting in Excel is sufficient for Uniform Invoice Software (Excel Invoice Manager) to run. However if you have changed the security setting there are chances that Uniform Invoice Software (Excel Invoice Manager) cannot run on your computer.

To check the security settings in Excel 2000/XP/2003:

  1. Click Excel menu Tools -> Macro -> Security.
  2. Go to the "Trusted Publishers" tab.
  3. Make sure "Trust all installed add-ins and templates" is checked.
  4. Restart Excel if you change the option.

Excel 2007 and Excel 2010 offer similar options. To check the options:

  1. In Excel 2007 click Excel menu Office button -> Excel Options; In Excel 2010 click File -> Options.
  2. Click Trust Center.
  3. Click Trust Center Settings.
  4. Click Add-ins.
  5. Make sure "Disable all Appliation Add-ins (may impair functionality)" is not checked.
  6. If "Require Appliation Add-ins to be signed by Trusted Publisher" is checked, make sure you add our publisher certificate to the trusted publisher list.
  7. Restart Excel if you make changes to the security options.

G. A Hidden Instance of Excel Is Running in the Background

For example, another program is opening an Excel template/workbook by running Excel.

To solve this, close the other running program or restart your computer.

H. 64-bit Excel/Office

TIP: Since Aug 4 2013, Uniform Invoice Software now supports all 64-bit Windows and Office.

If you are running 64-bit version of Excel/Office 2010, you should see an error message when you were trying to install Uniform Invoice Software (Excel Invoice Manager), because 64-bit Excel/Office is currently not supported.

Uniform Invoice Software (Excel Invoice Manager) is a 32-bit addin program. Microsoft has a document for 64-bit Office, please see 64-bit editions of Office 2010.

I. Startup Status

Check the following.

  1. Start your Excel.
  2. Click Office button, and then click Excel Options. In case of Excel 2010 or 2013, click File and then Options.
  3. Click "Add-ins" on the left pane.
  4. Choose "COM Add-ins" from the "Manage" list (right pane, bottom)
  5. Do you see "Uniform Invoice Software" listed on the dialog box? If it is not checked, check it now and then click OK.
  6. Is it working now?

J. Update for Office 2003 (KB907417)

If you are running Office 2003 and .NET Framework 2.0, try to download and install the Update for Office 2003 (KB907417) from Microsoft.

K. Security Policy

If the computer is joined a domain, make sure the domain administrator didn't create security policies to prevent your Windows account from installing new software programs.