Make a custom macro button on the Ribbon Menu in Excel.
Excel Quickie 39: • Excel VBA Get Relative...
How to Make a Personal Macro Workbook: • Use Your Macros in Any...
This is an awesome feature for later versions of Excel that allows you to customize the ribbon menu and add custom sections and buttons for your macros.
This tutorial follows the one that shows you how to make a personal macro workbook, where you can store macros so that they can be used in any open workbook or instance of Excel and that tutorial is linked-to higher up in this description.
Remember that adding a button to the ribbon menu will add it for every instance of Excel and not just the one that you are currently viewing.
Enjoy this Excel Quickie!
Stay Safe!
TeachExcel.com
#excel #tutorial #excelquickie
8 апр 2020