Enabling Excel Macros

Enabling Excel Macros
To enable macros, launch Excel, go to the top Tools menu and select Security. Next, select the security "Medium" or "Low" option. The "Low" option is recommended. If you do not choose the "Low" option, then Excel will prompt you every time you open the XLEcom program to allow macros.

Enabling Excel XLM Macros
If you cannot run the XLEcom program due to Excel's XLM Macro security issues, then please read the following.

For security reasons, Microsoft has initially disabled the usage of a XLM macro functions in the default installation in some versions of Excel 2002, 2002 and 2003 due to the fear of Macro viruses. However, Excel 2000, 2002, and 2003 still supports XLM macro functions, but one must enable the use of these functions manually.

According to Microsoft's web site, all that is needed to enable Excel's XLM macro functions is a simple registry entry. This registry entry is simply an "on" switch which allows Excel to access XLM macro functions.

To save time, we have provided the following registry file for Excel 2000, Excel 2002, and 2003 that will make the required registry entry for you. All you have to do is download the registry file (*.reg), double click on it and choose "Yes" when prompted to "add the information to the registry". That's it. You can also choose to open (install) it directly from the download option presented to you from your browser.

To enable full Macro support, download and open (install) the following registry file:

Enable_Excels_full_macro_support.reg

Below is the code within in this Registry file.

REGEDIT4

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Excel\Security]
"XLM"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\Excel\Security]
"XLM"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Excel\Security]
"XLM"=dword:00000001


For more information regarding this issue, visit Microsoft's Web site at:

http://www.microsoft.com/office/ork/xp/two/admc04.htm
and
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q291206