No video :(

Custom Macro Ribbon Menu Buttons - Excel Quickie 40

Подписаться 253 тыс.

Просмотров 14 тыс.

50% 1

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

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 11

@justreal9354 3 года назад

Short but awesome! Thanks for the information! 😊

@wayneedmondson1065 3 года назад

Nice one! Thanks for the tip. Thumbs up!!

@mobinam5350 2 года назад

Awesome! thanks!

@bryonlim3183 Год назад

Thanks!

@jonnathanjon1 4 года назад

Great video..Can you let me know how do I create a drop down menu like conditional formatting menu with different macros under them to select?

@TeachExcel 4 года назад

If you use xml code it is not difficult, but I'm not sure about doing it via the visual interface that I show in this tutorial.

@ananthimohan8762 2 года назад

Evey item I click the macro in the ribbon... The original macro workbook open.. I dnt want this... How to prevent it

@stephanweaver1960 4 года назад

As presented it is a limited use if you send a spreadsheet to somebody they cannot use that button - it tries to access a macro through the original file's location. I don't know if you know I work around?

@TeachExcel 4 года назад

If you send a spreadsheet to someone, this button should not carry though - the button is specific to your Excel instance. If you want to send someone a custom ribbon menu item, that would be different that just sending a regular plain old Excel workbook.