MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Macro Security

August 23, 2017 - by Bill Jelen

Excel Shortcut - Macro Security

I love VBA macros in Excel. But if I give someone a small macro, and if you've never used macros, you need to enable macros on your copy of Excel. Today, a keyboard shortcut to make this simpler.

Change Macro Security with Alt + T, M, S. Activate Add-Ins with Alt + T, I

These are really useful now that the settings are buried deep in Excel options.

Thanks to Ron de Bruin for sending in this idea.

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 21 37 changing macros security
  • when I'm working with someone and
  • they've never run macros before I'm on
  • the phone with and I'm trying to tell
  • them how to change macro security it is
  • a hassle to go into file options trust
  • Center trust Center settings and then
  • macro settings and then disable macros
  • without notification I say look just do
  • this
  • Alti for Tim M for Mary S for Sam and it
  • gets them right to that dialog box that
  • used to be alt T would open the Tools
  • menu in Excel 2003 and would be macro s
  • would be security definitely a faster
  • way to go and then related to that one
  • if we need to enable an edit well do you
  • have solver add software available that
  • file options add-ins go to the lower
  • left-hand corner choose regular Adams
  • click go and then you get finally get to
  • this dialog box just alt T I so I just
  • say look press alt T for Tim I for Irene
  • and click check the box for solver two
  • cases where the old old keyboard
  • shortcuts are dramatically faster than
  • the new way to get there all right well
  • hey I want to thank you for stopping by
  • all we'll see you next time for another
  • net cast from MrExcel

Title Photo: Gadini / Pixabay

Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.