Join Dennis Taylor for an in-depth discussion in this video Working with existing macros, part of Excel for Mac 2016: Macros.
- It's not uncommon to be introduced…to macros by way of existing macros.…In this workbook called Introduction,…there's a worksheet called Budget 2018.…Now, you've been told there's a macro in this worksheet.…Maybe you don't know much about macros.…The keystroke shortcut, option + command + B,…that lets us display larger values in millions,…with a single decimal.…In the lower right-hand corner,…I'm going to zoom in on this.…Let's imagine that we want to test this.…You've been told about this keystroke shortcut.…
Now, keystroke shortcuts to run macros…on Excel for the Mac involve the option and command keys…and possibly the shift key.…Ultimately, you have only maximum…52 possible keystroke shortcuts.…You can only use a letter.…Now, we're not talking about creating them,…but actually using them right now.…This keystroke shortcut is option + command + B.…So, let's try it.…Option + command + B.…It displays these numbers in millions.…Now, the pure value is still there.…
We don't necessarily see that at the moment.…Sometimes you say, "Well, okay, that looks okay.…
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