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

Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.