Using 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 an ActiveX control.

0 0

Post a comment