G
Guest
Hi all.
I have been making a series of "autofill" type macros in excel with buttons
in my tool bar.
While they're working great, today it dawned on me that I should be able to
have fewer items if I were to have a drop down menu as one of my tool bars.
This would allow me to have autofill names in the drop down, instead of
having to have 25 or so buttons across the top of my worksheet on top of all
the other single click icon/buttons.
I have found, and see where I can place drop downs within the worksheet
itself, but haven't yet figured out how to get it to work for the tool bar up
top.
1- is it possible to have a drop down menu on the excel tool bar? Not in the
worksheet....
If so, how do I make it?
If I'm in the wrong place, please move this post over to the right spot, and
let me know.
Thanks.
I have been making a series of "autofill" type macros in excel with buttons
in my tool bar.
While they're working great, today it dawned on me that I should be able to
have fewer items if I were to have a drop down menu as one of my tool bars.
This would allow me to have autofill names in the drop down, instead of
having to have 25 or so buttons across the top of my worksheet on top of all
the other single click icon/buttons.
I have found, and see where I can place drop downs within the worksheet
itself, but haven't yet figured out how to get it to work for the tool bar up
top.
1- is it possible to have a drop down menu on the excel tool bar? Not in the
worksheet....
If so, how do I make it?
If I'm in the wrong place, please move this post over to the right spot, and
let me know.
Thanks.