•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:
There you have it! Now you don't have to enable the macros every single time that you open Excel.
Slide 67 2. Click the "Excel Options" button in the lower right.
1. In Excel, click the Office button in the upper left corner of the screen.
3. Click the "Trust Center" button on the left. Then, at the bottom right, select "Trust Center Settings" as shown below.
4. In the next window, select "Macro Settings," then select the radio button for “Enable all macros."