Join Dennis Taylor for an in-depth discussion in this video Running a macro from an object or picture, part of Excel for Mac 2016: Macros.
- [Instructor] In addition to running a macro…by way of a menu or by way of a keystroke shortcut,…you can also run a macro by way…of an onscreen button or an object or picture.…In this workbook called Phone List,…a worksheet called Phone Numbers…has data in columns A, B, and C,…and the little buttons that we see in columns A and B…are practically inviting us to use them.…The list you can currently see is sorted by name.…If we want it sorted by department,…I'll simply slide the mouse over the blue button…here in column B, there's that pointing hand,…I'll simply click, and the list is sorted by department.…
Now, so you'd probably know that in this workbook,…there are macros here, and these buttons…are associated with the macros.…We don't necessarily have to see them,…but just a quick check on the Developer tab…to note by clicking the Macros button,…second one from the left, we do have…two macros in this workbook, one called…SortByDepartment, one called SortByName.…We don't have to look at the code necessarily…but just to know that they're there.…
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