O'Reilly logo

VBA and Macros for Microsoft Excel by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

24Using Custom Menus to Run Macros

So far, you've learned how to do just about everything with Excel VBA. You now need a way to allow your client to run your macros when they wish.

I definitely prefer giving the client a customized menu or a customized toolbar. There is nothing like having a user open his application and to see his name in the Excel menu bar. I will show you how to build fully customized menus or toolbars for your application.

There are other alternatives for running a macro. At the end of the chapter, you will learn how to use a keyboard shortcut, attach a macro to a command button, and attach a macro to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required