Join Dennis Taylor for an in-depth discussion in this video Running a macro from the Developer or View tabs, part of Excel for Mac 2016: Macros.
- [Instructor] In this chapter,…there are three different movies and each of them…talks about running a macro and in different ways.…As we talk about how to do this with the Developer…or View tabs, let's also remind ourselves…that if we are working with macros frequently,…we will want to become attuned to them…and there are two settings that should be turned on.…Let's go to Excel, Preferences…and under Security and Privacy,…make sure the box that says…Warn me before opening a file that contains macros…and you'll see the popup box causes a warning message…to appear whenever you open a file that contains macros.…
You can choose whether you want to disable macros…before opening a file.…So, if I turn this off and then open a file,…I'm going to open a file that has macros in it.…If I can see the file extensions like this one here,…PhoneList.xlsm,…I'm getting no warning whatsoever.…Now, question is, why do I want to get the warning?…Let's close this file.…File, Close.…Let's go back to that setting again.…Excel, Preferences, Security and Privacy.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros