No video :(

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4)

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

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

50% 1

Sign up for our Excel webinar, times added weekly: www.excelcampu...
Learn how to add custom macro buttons to the Excel Ribbon or Quick Access Toolbar.
This allows you to run macros from your personal macro workbook at any time, on any open workbook.
Read the article and download the Excel file here:
www.excelcampus...
The Excel ribbon can be customized with new Tabs, Groups, and Buttons that will run your macros.
You will also learn how to add macro buttons to the Quick Access Toolbar (QAT). The advantage here is that you can use the Alt+number key keyboard shortcuts to press a QAT button to run your macro. This makes it really fast to run a macro on any open workbook.
Other videos in this series:
How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4):
• How to Create a Person...
Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4):
• Where Is The Personal ...
How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):
• How to Add a Yes No Po...
Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!

Опубликовано:

20 мар 2016

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@hughrobinson4147 5 лет назад

Thanks for making this video. I am using an older version of excel (2007). I just added it to the Quick Access Toolbar. This will save me a lot of time once I make all my macros to use on all my spreadsheets. Thanks again.

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

Thank you so much for sharing. Looking forward for more videos with deep learning of VBA.

@SwiftlySwift13 6 лет назад

Thankyou so much! I have been searching the internet for what seems like forever to work out how to do this!!

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

very useful video, my ninja. you made it very easy

@sandraellis5561 6 лет назад

This is fantastic help for speeding things up. Thanks for taking the time to do it so clearly!

@kellyboyd295 9 месяцев назад

Thank you!

@ExcelCampus 9 месяцев назад

You're welcome! 😀

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

Thank you so much for the free training. It helps to my job

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

Thanks for the vidéo

@user-ru6rk4tb8t 9 месяцев назад

Very nice and smooth learning

@ExcelCampus 9 месяцев назад

Thank you! 😀

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

Very helpful. Thanks!

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

LOVE THIS CONTENT!

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

Thanks a lot

@ductn9 5 лет назад

Thank you! Great tutorial!!!

@khalidmajeed2886 2 месяца назад

great sir knowledge provider

@chrisklimantiris2520 Год назад

Thank you, John !!

@vigneshwarank529 5 лет назад

Thank you Jon for the video

@user-gs8qm9rw6r 2 года назад

Perfect Guide!

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

pro tip : if hes going too slow in the video for your liking then just bump up the playback speed to 1.75 saves a bunch of time.

@apiitg 5 лет назад

Thank you so much. This is a great series. You are a great teacher and an excel genius.

@pickymissmn 7 месяцев назад

Great video! Showed me exactly what I needed to know quickly! Thank you!

@ExcelCampus 7 месяцев назад

Glad it was helpful! 😀

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

good intro and useful info, thank you

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

Awesome Video !

@shravankumar-of5qg 3 года назад

Hi, its really helpful, thanks👍

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

thanks :) I like this elegant solution. :)

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

Indeed a very useful tip.... thanks a lot. 🙏🙏

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

My pleasure 😊

@jfyfe67 6 лет назад

Very nice explanation and well presented!

@hwangmy0307 8 лет назад

Thanks for your Great Video

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

Thank you sir!

@alfredcalleja450 5 лет назад

Thanks very clear and concise.

@gregkeith9521 6 лет назад

This is awesome and very well done!

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

Thank you..very helpful...

@johnpaden8360 5 лет назад

Excellent content. Well-organized presentation.

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

thank you helped a lot. Knew this was there somewhere in Ms Office

@smilewithdevesh 7 месяцев назад

Great work❤

@ExcelCampus 7 месяцев назад

Thank you! 😊

@HforHelm 5 лет назад

It helped me in my work thank you sir.

@YHDPM 5 лет назад

Awsome work, very useful. Thank you.

@erich7195 8 лет назад

Great series.. these videos were very helpful.... much appreciated.

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

Good info 👍🏻 Let know if we can add our own pictures in addition to the existing ones which we see if select INSERT -> PICTURES Option. Thanks

@sTdwares 7 лет назад

Awesome! Just tell me this one thing. If I export customization in my computer and then later import it on your computer, do I have to share my Personal Workbook with you as well, or will it take care of that automatically? How would your computer find the Macros that I have stored in my personal workbook, otherwise? Thanks for explaining this...

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

great video thx

@armaansalman1249 5 лет назад

Hey first thanks for sharing your good work and knowledge. I am facing problem in saving after customizing, when i reopen and try to run macros it gives error but when i Import save customization UI file it runs.

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

Hi Thanks a lot for sharing this. Kindly help, how we can add a tab including a group and other macros to other system, like AddIns.

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

Thanks..

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

Hi Thank you for useful information. I have created a custom ribbon through Xml UI Editor and want to callback a User Defined Function from a button on the ribbon control. For instance, the way a built-in formula is inserted in an active cell. Hope my question is clear. Thanks

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

Thank you for the clear explanations! Is there a way to add the new buttons in the ribbon only when the user opens the workbook (or addin) containing the functionality launched by the tools? I also need to know how to remove those new buttons in the ribbon, as soon as the user closes the workbook (or addin) carrying that same functionality. Can we do this with VBA?

@bcBiz 5 лет назад

Thank you

@franciscoveras7405 5 лет назад

Hello Jon, this video has resolved part of my problem, here is the second part: It's there a way to keep this buttons while using the file in another computer?, I have created the buttons but they disappear when I open the file in another computer, Thanks

@riccardovitaletti640 5 лет назад

Great, thank you very much. So hard to do it through external apps. Is it somehow possible to custimize the icons using external images?

@mnaumanak 6 лет назад

Hi Jon, thanks for explaining how to make a macro available in new workbooks. The concept of Personal workbook is very well explained. I have a question, if we have a user function and we want this function to be available for all the new workbooks we create, how do we achieve it.

@pasaico 6 лет назад

I have created a macro in a file.xlsm , then i have add this marco in customize ribbon (same this video) , every time I run it with the button on the ribbon, the macro works but the file.xlsm always opens....How can I avoid this?

@maxpervaiz568 5 лет назад

Thanks for a great video. Customize QAT has the ability to assign a macro specific to the active workbook itself (e.g., see a Drop Down menu on the top right side which can be selected for your active book - it is listed under "For all documents (default)"). That way you will only assign the macros which are available in the active book in the QAT itself. There does not seem to be an ability to do the same with the custom ribbon itself. You can only use the "Main Tabs" selection which forces all your spreadsheets to have the same buttons. Is it possible to segregate the macros on a book by book basis in a user defined custom tab?

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

Hi Jon, Thank you for this wonderful explanation and sharing knowledge. It helped me in a great way, although I am facing a problem which is : when I send this excel file to other people they don't see the customization I've made. Can you please help? Thanks.

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

Thanks for the help. After doing this I noticed that the customized ribbion is showing in every open workbook. Is there any way to cusomize ribbion for one particular workbook ?

@AnalyticsInDetails 7 лет назад

What an explanation,wOW......

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

First of all thank you so much for the idea. When I open a new Excel file, I could see my Macro under menu but when I press the button, open my original created file. Any idea to add these keys without original file open?

@37no37 5 лет назад

Hi, thank you for your Video, as you say you would like to help: the buttons I am trying to create in my VBA editor is about IF THEN and FOR NEXT button so I don't need to write this statements all the time, just click and write the variable, how is possible to do that. thanks.

@petesmith487 Год назад

Thanks. Great video. The custom ribbon /toolbar creates the icons for me as described but the macro won't run from there due to a security setting I cannot find. (The macro runs fine from the standard macro list). Pulling my hair out 😂

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

Hi Jon, thank you for the video. I have two questions. 1) Is it possible to customize only a specific template and not Excel in general? I think it is, because in my office we use a tool developed in excel that has a special tab that is showed only in that specific file or in its copies. How do I customize only a specific file? 2) Do the customized tabs have to be necessarily related to macros belonging to the Personal workbook or whatever module present in the current workbook is good? Thank you, bye, Marco.

@mikemebane9095 6 лет назад

Hi Jon... awesome video. Question, how do I delete old macros that I don't use any longer... they seem to occupy my logical short-key I use to run my macros

@amndev94 6 лет назад

Awesome Video. Thanx... ONE QUESTION : Is there any way to create dropdowns in the ribbon ?

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

I saved off the customization you said to import it onto a new pc can be done. So i have that file it created do i need to go through the customize ribbon to get to that import button and then just click that?

@TechHelpYT 5 лет назад

thank you

@user-wz9xf7ds1g 11 месяцев назад

Hi John, I am trying to create this tool bar and I've been following your videos. First, when I pasted the file location, nothing was saved at the XLSTART file. Second, when I created the tab and tried to transfer the macro I had created, it was not an option. I feel like I'm missing something. --Dulce

@BuildFriendly Год назад

Do the macros need to be "public" to be available to assign? Can they be inside of a userform in the Personal.xlsb?

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

How do I attach it to the word file? I want the Macro buttons to be available to anyone who uses the excel file?

@user-fu4cy2ei2s 2 года назад

Thanks for video. Can you advise is there any way to expand collection of icons (symbols) which can be assigned to macro? A standard one here 1:59

@shailendrakumar7989 6 лет назад

Good Sir

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

hi :) excellent...I just added 3 sheets, but when I click on Marco it adds me 6 sheets :)

@Golwe 7 лет назад

Thanks. However while my buttons do show up in the QAT but they won't run the macros. The macros won't run from the button on the ribbon either. Changing settings in "Trust Center" does not help. The only way I can get my macros to run is by hunting them down in the Developer tab.

@CW-oo4yx Год назад

It seems that there are a lot of information that doesn't apply to Mac users. It would be nice to know if the training would apple to Mac user. Or maybe cover the lessons for Mac user.

@rohan.chandratre 4 года назад

Finalllyyyy!!!

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

If i share the file will the tab will appear on another device?

@usmanali81 7 лет назад

good

@patricialee6675 6 лет назад

Once you add a macro to the quick acces tool bar and ribbon, do you have to update the tool bar and ribbon if you make changes to the marco.

@lore581 Год назад

hello, any idea to add a "save as" button to save just a specific pivot table (I want the user to choose which pivot table need to save)

@ExcelCampus 11 месяцев назад

I'm not sure I fully understand, but I believe this could be done with a macro. You could copy the pivot table to a new workbook. You would just need to be conscious of if you want it to link to the source data in the original workbook, or be the report only. Any actions you take to set this up manually could be automated with VBA. We do have a community forum inside our Elevate Excel Training Program where members can ask more detailed questions like this. www.excelcampus.com/elevate I hope that helps. Thanks again and have a nice weekend! 🙂

@steverollins6990 6 лет назад

good stuff... do you have a video on creating an add-in? I want to make. my macros from this one module to others in my Dept... but I don't want to make them have to create a workbook called personal. xlsb, and save it in the xlstrart directory

@Naresh13Kumar 5 лет назад

Is there any way to keep our own icons instead of picking up only the available icons ?

@rontindoy5738 7 лет назад

How about when you open a file the workbook creates a temporary add in and disable temporarily some of the usual add ins

@catuvanoli 7 лет назад

What should I do if I want other people who open this workbook to have the same tab and use it without having to enter to the customize ribbon right click option? Thanks

@ExcelCampus 7 лет назад

Hi Catu, In this case you can customize the Excel ribbon with XML code. I explain how to do this step-by-step in my VBA Pro Course. excelcampus.com/courses. I hope that helps.

@rajeevgosavi4514 Год назад

After Creating macro and tool belt, when running macro, It shows run time error 9. Kindly advise the solution.

@vigneshwarank529 6 лет назад

Dear sir greetings I have to know that if we exporting UI file to another computer. Is Macros also copied to it?. Thanks in advance

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

Sir, I have done this in my system and if I wants to convert this as addin ? Like group of multiple VBA programs which are already in ribbon to convert as addin and share it with others directly is it possible???

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

Hi. Hello from Argentina. If I customize my Excel Ribbon whit personals macros and I want to export it to another computer: ¿ Is enoughf the Import/ export Excel Customizations? ¿Will the macros stores in the PERSONAL.XLSB be exported? Thanks!

@rennieb_me 7 лет назад

Hi Jon, thanks for this series! I found so many videos on macros but not many about orienting the user with regard to navigation. totally clear now. With regard to the export import feature, will it carry my actual subroutine with the ribbon export or only the superficial buttons? I've recorded a macro that I'd like to make accessible on another pc. I'm guessing that I will have to save my PERSONAL doc to a jump drive to transfer the macro to the alt PC... but importing the buttons and actually attaching it to the macro is unclear. If you have opportunity, please clarify. Thanks again!!

@ExcelCampus 7 лет назад

Thank you Sherinne! You are correct. That is a great question and I should have explained it better. The CustomUI file that you export does not contain the macros or files that the macros are in. It just contains the buttons. So you will also need to transfer the Personal Macro Workbook to the other computer and put it in the XLStart folder. In video 2 of this sereis I explain where the file is stored. Here is the link. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6cynP3OkIT0.html

@rennieb_me 7 лет назад

Excel Campus - Jon you're the best, thank you much!

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

The whole process is pretty complex, definitely not straightforward! I would have never found out how to do this. So: thank you very much!

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

You say that if “I get a new PC I can import my Macros “? Therefore, when I transfer my files to my new PC does not transfer my macros ? Sorry for the confusion. Hope you can reply. 🙏

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

How do I make a button for Mac? After following the steps, when I get to rename I do not have the option to choose a symbol and it shows on the excel as an invisible button that can still be clicked.

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

Won't it be available only for you/on your computer? What if I want to send this file to someone else via email? Will this person also have access to those buttons?

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

Does this work on a MacBook?

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

How to make a Menu in VBA Form?

@mariasimas5861 7 лет назад

In my office you do not have the customize ribbon option, how do I? My office is 2016, I really wanted it was that the menu I created with the Ribbon appeared in all excel

@YouWiking 6 лет назад

Hi JonI have made my macro and added it to the ribbon, but when I press it, nothing happens but if I use the shortcut keys it works. I've tried removing the shortcut keys, but it doesn't seem to make a difference.Hope you can help and thank you for the video.

@YouWiking 6 лет назад

Hey Jon, I worked it out. The Personal makro folder was disabled :-(

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

How can I use my regularly used file to Custom Ribbon to use when I click on it, without using vba or macro

@Popart-xh2fd 4 года назад

But don't you lose all those configs once the file is open on other computer?

@joshuasamuelwillemse4476 7 лет назад

I have a question. How can I add the "Design" tab in the ribbon in excel 2013? I was able to add developer but i dont seem to have a use for that yet. That being said i have one more question. How can i get a worksheet/template to run like a combined one instead of seeing a bunch of tabs at the bottom of my excel. The template was bought and is used for various things which after it is all added up in the first few sheets of the template it shows the outcome of the total added. On my Win 10 YogaBook it works fine but on my laptop its not and its the same template. Please help.

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

When we copy files excel to other laptop, those other laptop have code in Ribbon as this video?

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

Great question Seang! No, the ribbon does not travel with the workbook for this type of setup. You will have to setup the same ribbon buttons on your laptop as well. You can click the Import/Export button on the Customize Ribbon tab to export the customizations, then import them into Excel on your laptop. If you want the buttons to travel with the workbook then you can create an Excel Add-in (xlam) or Macro Enabled file (xlsm) and use Ribbon XML to create the buttons. This requires creating XML code in the file to create the buttons. I hope that helps. Thanks again and have a nice day! 🙂

@Popart-xh2fd 4 года назад

How to activate "My Macros" with a macro instead of using the Config options?

@NsoundarMCA 6 лет назад

hey jon, i have a question here that i have created the module in a excel and the same was worked fine. However once i closed the excel and reopened the same i can't see that module thus i'm unable to use from 2nd time onward, how to use/store permanently

@AlbatrossPtrs 5 лет назад

How do I do the same in excel 2016 for Mac, pls?

@morneerasmus1789 8 лет назад

Hi Jon, do you perhaps know how to add a description on hover? Other ribbon items have descriptions when you hover over them. Thanks M.

@ExcelCampus 8 лет назад

Hi Morne, I don't know of a way to add the screentip (description) to this type of ribbon customization. You can modify the screentip and supertip when you create an add-in with CustomUI XML code for the ribbon. The CustomUI code gives you a lot more option for customizing the ribbon to add your own button images, screentips, and various control types (buttons, drop-downs, checkboxes, etc.). I hope that helps.