Custom Menu Bar in Excel 2007
I am new to Excel 2007 and have two questions. 1. In previous versions, i
was able to create a custom menu bar as a drop down from the top menu and add
macros to it. I could do all of this without having to go in and write code.
Now in 2007, i see how to add a menu bar to the quick access tool bar, but i
can't figure out how to assign macros to that menu bar. Any ideas? 2. How
do you go about creating an add-in that other users could add to their
computer and use? I have never done this before and wanted to know if that
is a good way to share a custom menu bar or tool bar?
Thanks.
|