Macro menus


show more Macro menus provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Macro menus

In a previous lesson we recorded two macros; one that we considered to be more useful and one that we considered to be less useful. Here in this workbook I've recreated the more useful version of that macro and now let's look at assigning that macro to your menus, toolbars and your own custom menus. It's a lot easier than you'd think. Earlier, we assigned shortcut keys to our macros, so they're already at our disposal without having to go through the Macro menu. We could simply insert a row, type in a title, highlight some space here, and that second macro we put the Control+T shortcut, so let's do that, and viola, our macro takes effect. Now I'm going to delete that information so that we can do it again. Let's insert a row and put in QUARTERLY SALES as our title. Only this time we're going up to the Tools > Customize menu and as long as this menu is open, we have all kinds of options. Let's go to the Commands and we'll scroll down throug...

Macro menus
Video duration: 3m 44s 4h 8m Beginner

Viewers:

Macro menus provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...