Friday, July 22, 2022

Video: Assign a button to a macro [MS]

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

In this final video, we'll hook the macro up with a button and make it available in two places: In a custom group on the Developer tab, and on the Quick Access Toolbar.

Want more?

Create or delete a macro

Edit a macro

Assign a macro to a button

Create and save all your macros in a single workbook

In this final video, we'll hook the macro up with a button and make it available in two places.

In a custom group on the ribbon that I'll create on the DEVELOPER tab, I'll call My Macros, and up here on the Quick Access Toolbar.

First, I'll create a custom group for the DEVELOPER tab.

I click the FILE tab, Options, Customize Ribbon, and then I make sure Developer is checked.

I click New Group and here is our new group.

I click Rename, and call it My Macros.

Now, let's find the macro and add it to this custom group.

I go over here and choose commands from Macros.

I select the "FillDaysRelativeR" macro that's stored in my 'Personal Workbook' and click Add.

Here it is, it's now in the group and I want to rename it.

I click Rename and call this "Fill Days".

You can have spaces in display names.

While I am at it, I'll replace the cryptic icon with this icon that looks a little bit like a calendar.

I click OK, click OK again and here's my macro button in my custom My Macro group.

I click it and it works.

Now I'll show you how to add the same macro to the Quick Access Toolbar, so it'll be up here next to Redo.

Click FILE and Options, and this time, click Quick Access Toolbar.

Again, I choose commands from Macros, and here's the macro in my personal workbook. Click Add.

To rename it, click Modify. Call it "Fill Days" and choose the same grid icon.

I click OK, and click OK again.

Now here it is, up on the Quick Access Toolbar.

I click it, and of course, it works great again.

Now you have a pretty good idea about how to implement macros in Excel.

Of course, there's always more to learn.

So check out the course summary at the end, and best of all, explore Excel 2013 on your own.

No comments:

Post a Comment

Search This Blog

Work in channels [MS]

Try it! ...