Monday, February 22, 2010

How do you automatically enable macros when Excel is opened?

Slide 66
To automatically enable all macros when Excel is opened so you don’t have to do it manually every time, please read the following instructions:
Slide 67
1. In Excel, click the Office button in the upper left corner of the screen. 
 
 Slide 67 2. Click the "Excel Options" button in the lower right.

  
Slide 67
3. Click the "Trust Center" button on the left. Then, at the bottom right, select "Trust Center Settings" as shown below.
 
Slide 67
4. In the next window, select "Macro Settings," then select the radio button for “Enable all macros."
 
  There you have it! Now you don't have to enable the macros every single time that you open Excel.