Learn how to copy macros from one workbook to another. Author Jen McBee demonstrates the steps to copy a macro from another workbook using Visual Basic.
- [Instructor] Did you know that you can copy Macros…from one workbook to another?…Yes you can and I'm gunna show you how.…We're going to create a simple macro,…and then we'll copy it from one workbook to another.…We're gunna be working with two workbooks.…The first is the 02_05 Copy_Macros.…Let me go to my view tab and switch windows.…The other document is the 02_05 Macro_Destination workbook.…Let's go back to our 02_05 Copy_Macros workbook.…
Now, you can create macros either…on the view tab in the macros group,…or on your DEVELOPER tab in the code group.…If your DEVELOPER tab isn't showing, just right click…on any of the ribbons, go to customize ribbon,…and check off Developer.…After we create our macros, the macro…will show in our macro window,…and we'll be using Visual Basic…to copy the macro from one workbook to another.…
Let's go ahead and record our macro.…It'll be a macro that we can apply…to the Headings in our workbooks…with a white font, maroon background,…Arial 14 Bold and Italics.…I'll click in a blank cell, and click record macro.…
Author
Jennifer McBee
Released
5/4/2017Lynda.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. In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.
- Using templates
- Managing versions
- Leveraging macros
- Linking to external data
- Protecting cells
- Hiding formulas
- Using advanced Fill Series options
- Creating form fields
- Using advanced functions: AND/OR, SUMIFS, AVERAGEIFS, and COUNTIFS
- Manipulating options in existing PivotCharts
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Microsoft Office Specialist (MOS) Expert Exam Overview
-
2. Manage and Share Workbooks
-
Create and modify templates4m 15s
-
Link to external data6m 51s
-
-
3. Apply Custom Formats and Layouts
-
Create form fields5m 1s
-
4. Create Advanced Formulas
-
Use a Nested IF function3m 54s
-
Use the AND/OR functions6m 21s
-
Use financial functions3m 24s
-
-
5. Create Advanced Charts and Tables
-
Create new PivotCharts3m 39s
-
Apply styles to PivotCharts4m 20s
-
-
6. Sample Exam
-
Conclusion
-
Next steps30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Copy macros from workbook to workbook