Macro (enable) – TJS

Macros are sets of instruction that work behind the scenes, and used by TJS to give you a better user experience. It will be necessary to allow them to run when using the product, however – Excel gives you choices on how to enable them.

You can choose to enable macros by clicking the Excel “warning” message near the top of your sheet, or better yet… have Excel automatically enable macros (recommended)*. To do this, please spend a moment by following these instructions:

Excel 2007

  1. Click MS Office Button (top-left).
  2. Click “Excel Options” (bottom).
  3. Click “Trust Center” button (left-side).
    • In same window, click “Trust Center  Settings (right-side).
  4. Select “Macro Settings” (left-side).
  5. Choose to “Enable all Macros…”
  6. Click “OK”…
  7. Save and Close Excel program.
  8. Reopen Excel.

Click for Excel 2007 >>

Excel 2010

  1. Click green File button (top-left).
  2. Click “Options” button (bottom-left).
  3. Click “Trust Center” (left-side). 
    • In same window, click “Trust Center Settings (right-side).
  4. Click “Macro Settings” button (left).
  5.  Choose to “Enable all Macros…”
  6. Click “OK”…
  7. Save and Close the Excel program.
  8. Reopen Excel.

Click for Excel 2010 >>

Excel 2011

  1. On the Excel menu, click Preferences.
  2. Under Sharing and Privacy, click Security.
  3. Select the “Warn before opening a file that contains Macros” check box.

Click for Excel 2011 >>


File icon

Macro enabled file icon

*While performing the above instructions, Excel will say this is not recommended. This is true if you commonly download Excel files from the internet, not knowing where they come from (that contain macros). if so, just use Excel’s ‘warning’ message to enable macros each time you open the file.

Once macros are enabled, the file icon will have a yellow exclamation point on it and the file extension will be (.xlsm), instead of (.xlsx).

… as seen in the image to the right —>