You are here: HOME >>> Excel Invoice Manager

Removing Auto-created Macros from Your Invoice Template

Microsoft Excel creates/records macros automatically when you double-click an ActiveX control, like a button or an image object, in design mode. The macros are usually empty - i.e. they don't contain any code.

Although Excel Invoice Manager itself does not use any macro, those auto-created macros could cause problems.

The Problem

If you save the auto-created macros with your invoice template, and then re-open the invoice template, Excel may display one of the following error messages, depending on the version of Excel you are running and the security level setting of your Excel. (All screenshots below are taken from Excel 2003).

Security level: Very High.

Warning message when security level is very high
(Click to enlarge)
Security level: High.

Warning message when security level is High
(Click to enlarge)
Security level: Medium.

Warning message when security level is Medium
(Click to enlarge)

Solution 1

To prevent Excel from creating macros automatically in design mode, try to click the controls (buttons, images etc.) slowly, so as to ensure that Excel does not think you are double-clicking the control.

To remove those auto-created macros from your invoice template, follow the steps below:

Open the invoice template.
Unprotect the Invoice worksheet. For information about how to do this in Excel, see Customizing the Invoice Template.
Press ALT+F11 key on your keyboard. This opens the Microsoft Visual Basic macro editor of Excel.

Macro editor (Click to enlarge)
Double-click a sheet name (say Invoice) in the Project pane. Excel displays the macros contained in the sheet in the right pane.
Click the right pane to activate it.
Press CTRL+A on your keyboard to select all the macros.
Press DEL key on your keyboard to delete all the macros.
Repeat step 4 - 7 for each worksheet in your template.
Click menu File -> Save.
Click menu File -> Close and Return to Microsoft Excel. This closes the macro editor and returns you to Excel.
Protect the Invoice worksheet. For information about how to do this in Excel, see Customizing the Invoice Template.
Exit Excel and re-open the invoice template. The security warning message disappears.

Solution 2

Should you like to start from scratch again, you can download the default (clean) template here: standard_invoice_template.zip.

Tip: The procedure described here works too for the free invoice template.

EXCEL INVOICE MANAGER Free Download and Try

LEARN MORE Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Setting up Company Information, Tax Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Copying Report Worksheets from One Invoice Template to Another Two Versions of Customer Statement Report Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Creating an Invoice Template with Additional Rows Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way Adding Postcode Cells Manually to Invoice Template More Topics Registration and Services Reference

Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer Sample Invoice Template: Replacing the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Sharing/Linking Tables between Access Databases Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices Customizing Invoice Template for Pre-printed Invoice Forms Charging GST Tax on Shipping Cost Invoice Form with Fixed or Static Product / Service Items Applying Discounts

Home	Contact Us	Privacy	Link to Us
copyright © Office-Kit.com, all rights reserved