I have a worksheet of macros and UDFs I use fairly often, and want to convert this to an excel add-in for ease of use by myself and others.
I am just unsure how to create the drop-down menu from the command bar, which will display the macro names and clicking on them will give the required functionality.
I have used userforms before, but require something different, I believe.
Very interested to hear from others who've done something similar.
Thanks in advance,