Skip to content

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 Macros to run when using your TJS

Excel gives you choices on how to enable them.

1) Enable macros each time you open your TJS by clicking the yellow Excel “warning” message near the top of your sheet, or better yet…

2) Have Excel automatically enable macros (recommended)*. To do this, please follow these instructions:


Windows 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 Windows Excel 2007 >>


Windows Excel 2010 / 2013 / 2016 / 365

  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 Windows Excel 2010 / 2013 / 2016 / 365 >>


Mac Excel 2011 / 2016 / 365

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

Click for Mac Excel 2011 / 2016 / 365 >>


*While performing the above instructions, Excel will state, “this is not recommended”. Please disregard this Excel warning, unless you commonly download Excel files from unknown sources (that also contain macros). If you prefer not to change this setting, you’ll just need to confirm Excel’s ‘warning’ message (to enable macros) each time you open the file.


 

Macro Enable Your TJS

Back To Top