VBA and Macros for Microsoft Excel

24Using Custom Menus to Run Macros

IN THIS CHAPTER

Creating a Custom Menu

Creating a Custom Toolbar

Other Ways to Run a Macro

Case Study

Next Steps

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 ...