From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Create simple macros and copy to another workbook
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create simple macros and copy to another workbook
- Now that we know how to enable and disable macros, let's take some time to learn how to create a simple macro. Once we create our macro, we'll rename the macro and edit the macro. I'll then show you how to copy the macro between workbooks. Let's take a look at our create copy macros workbook. Now they're are a couple of different ways that you can start the process of recording a macro. First of all, we can go to our View tab then on the far right-hand side, we have our macros group and this is where we can view current macros, record a macro and choose to use relative references. Now what that means is, by default our macros are recorded using absolute references. So for instance, if I start recording and then come down and select the range C4 to F11, finish recording my formatting, stop recording. Each time I run this macro, it will go to C4 to F11, select the cells and apply the formatting. That's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Enable macros3m 38s
-
(Locked)
Create simple macros and copy to another workbook7m 10s
-
(Locked)
Reference data in other workbooks7m 36s
-
(Locked)
Manage workbook versions6m 17s
-
(Locked)
Protect workbooks and worksheets7m 37s
-
(Locked)
Configure formula calculation options9m 52s
-
(Locked)
Manage comments5m 11s
-
(Locked)
Configure editing and display languages4m 58s
-
(Locked)
Challenge: Manage workbook options and settings2m 1s
-
(Locked)
Solution: Manage workbook options and setting9m 37s
-
(Locked)
-
-
-
-
-