From the course: Excel: Scenario Planning and Analysis
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Link a macro to a shape
From the course: Excel: Scenario Planning and Analysis
Link a macro to a shape
- [Instructor] After you have recorded one or more macros that recreate desired pivot table positions, you can add elements to your workbook that let you run those macros quickly and in the desired order. In this movie, I will show you how to link a macro to a shape, so that when you click the shape the macro will run. My sample file is Project_Analysis_04_07, which is a macro-enabled workbook that you can find in the chapter four folder of your exercise files collection. I just opened the file, and you'll see a yellow security warning bar, message bar, just below the ribbon and above the formula bar. This message bar indicates that the workbook does contain macros, and that they've been disabled. Macros are computer code, and like any other type of computer code, it can be a security problem. You can get macro viruses and other problems as well. However, in this case, I happen to know that the macros are okay, I created it. So I can click Enable Content to enable the macros to run…
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)
Define PivotTable dataset6m 23s
-
Create and pivot a PivotTable5m 30s
-
(Locked)
Summarize PivotTable data using subtotals and grand totals4m 22s
-
(Locked)
Filter PivotTable data5m 10s
-
(Locked)
Change the values area summary operation5m 55s
-
(Locked)
Record a macro to recreate a PivotTable position6m 37s
-
(Locked)
Link a macro to a shape6m 27s
-
(Locked)
Walk through a scenario presentation3m 46s
-
(Locked)
-