Wiley 978-0-470-03738-6 Datenblatt

Chapter 1: Building and Running MacrosIn This Chapter⻬ Understanding how macros do what they do⻬ Recording macros for instant playback⻬ Using the rela

Assigning Macros to the Quick Access Toolbar710Assigning Macros to the Quick Access ToolbarInstead of running a macro by selecting it in the Macro dia

Macro Basics702Macro BasicsYou can create macros two ways:✦ Use Excel’s macro recorder to record your actions as you undertakethem in a worksheet.✦ En

Book VIIIChapter 1Building andRunning MacrosMacro Basics703When you create a macro with the macro recorder, you decide not only theworkbook in which t

Macro Basics704command button on the Developer tab (Alt+LR), the macro recorder recordsall your actions in the active worksheet or chart sheet as you

Book VIIIChapter 1Building andRunning MacrosMacro Basics705list box to be able to run the macro anytime you like. Select This Work-book (the default)

Macro Basics706cell. Next, click the Bold button and then click 16 on the Font Size drop-down list on the Home tab. Finally, drag through cells A1:E1

Book VIIIChapter 1Building andRunning MacrosMacro Basics707Running a macroAfter recording a macro, you can run it by doing any of the following:✦ Clic

Macro Security708If you run your macro in a worksheet that already contains data in the cellsthat the macro uses, you run the risk of having existing

Book VIIIChapter 1Building andRunning MacrosMacro Security709The Macro Settings tab of the Trust Center dialog box also contains theseother option but