I am able to create a customized toolbar that runs a specific macro linked to it. My problem is that it is only associated with that specific worksheet where the macro is stored. If I close the worksheet with the macroand open a new worksheet, the custom toolbar ca't find the macro.
How do I create custom toolbars that will always be available in Excel, to use in any worksheet open at the time.
I am using the office VB design mode for coding. Can one only do this using VB.Net or similar?