Macros issue in Excel 2002

0 votes
asked Aug 1 in MS Excel Issues by Annie
My macros in Excel 2002 is not running can anyone knows what caused the problem, what can I do? Please help

1 Answer

0 votes
answered Aug 10 by lorein0688 (460 points)

Well, the issue is related to the high-security level and to fix the issue and a key to the registry that allows Excel to run XLM macros when the macro security level is set to High.

Follow the steps to do so:

Please note: It is recommended to back up your system as manipulating the registry Editor is quite risky, a small mistake can cause a serious problem and you might need to reinstall your operating system.

  1. Click Start > click Run. Then, in the Open box, type regedit. Click OK.
  2. Now, in the left pane, click the plus signs (+) to the left of the following items (in order): 

    HKEY_LOCAL_MACHINE
    Software
    Microsoft
    Office
    10.0
    Excel

3.       And on the Edit menu > point to New, > click Key > type Security > ENTER. 

4.       Next, on the Edit menu > point to New > click DWORD Value. 

5.       Type XLM > hit ENTER > double-click XLM. 

6.       Now, type 1 in the Value box > click OK. 

7.       Click Exit on the Registry menu.

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...