Note Macro names cannot contain spaces or special characters, such or!. In the Macro name box, type MySpecialTable, and then click Keyboard. On the Developer tab, under Visual Basic, click Record. Let's assign a keyboard shortcut to the macro that we will record in the next lesson. By assigning a keyboard shortcut to a macro, you will be able to run the macro at any time by pressing the shortcut keys. Assign a keyboard shortcut to a macro Before you begin recording a macro, you have the option to assign it a keyboard shortcut.
#Uwec excel download for mac for mac
Microsoft Office for Mac 2011 tutorial: Automate tasks with Visual Basic macros 3Ĥ 2. Before you move on Make sure that you can do the following: Show the Developer tab on the ribbon. Hints To rearrange or remove ribbon tabs from the ribbon, click Ribbon Options, and then click Customize Ribbon Tab Order. Notice that the Developer tab now appears on the ribbon. Microsoft Office for Mac 2011 tutorial: Automate tasks with Visual Basic macros 2ģ In the Tab or Group Title box, select the Developer check box, and then click OK. On the ribbon, click Ribbon Options, and then click Ribbon Preferences. In Word, click File > New Blank Document. However, the principles are similar in Excel.
#Uwec excel download for mac how to
Important This tutorial uses Word to demonstrate how to work with macros. Let's show the Developer tab on the Word ribbon. By default, the Developer tab does not appear on the ribbon. Show the Developer tab The Developer tab is a specialized ribbon tab that contains commands for working with macros. Estimated time to complete: 25 minutes Microsoft Office for Mac 2011 tutorial: Automate tasks with Visual Basic macros 1Ģ 1. Requirements Word for Mac 2011 Basic Word skills, including how to open a document, cut and paste, and format text. Record a macro to insert a stylized table. Before you begin Show the Developer tab Assign a keyboard shortcut to a macro Record a macro Run the macro Edit the macro Quick Reference Card Before you begin What you'll learn After completing this tutorial, you'll be able to: Show the Developer tab on the ribbon. For example, you might record a macro to apply specific page margins, insert a customized bulleted list, or insert a complex table. A macro is simply a recorded set of keystrokes and instructions that you can use to automate a task that you don't want to do from scratch each time. 1 Automate tasks with Visual Basic macros If you're not familiar with macros, don't let the term frighten you.
0 kommentar(er)
