there are thousands of people posting excel videos but this guy really stands out, he can do amazing things! To tell the truth it's a bit complicated for me, both for the project itself and for understanding the language... But, the little I understand, is enough to amaze me every time... Keep it up bro! Thanks for spreading your knowledge!
Thank you so very much, I really appreciate that Frank. I am so glad you enjoy the content and I am sure you will enjoy this video training. This one is a bit simpler and I write the code from scratch during the training
Hi Randy - a few months ago I spent a couple of weeks trying to design a custom ribbon toolbar, watched dozens of videos from other creators and ultimately was able to cobble it together. Your video is the perfect tutorial with everything needed all in one place! Many thanks for your teachings and for sharing your knowledge!
Great tutorial, Randy! I’ve wanted to implement ribbons in my Excel apps for several years & have watched many YT tutorials & read many blogs, but none laid it out clearly enough for me to move ahead. This tutorial is, by far, the best I’ve viewed on this subject. Clear, detailed explanations with many examples, including complex logic, that will enable me to start using custom ribbons in my apps. Finally! Thank you!
Awesome Jim, thanks so very much. I really appreciate that. I also added 3 additional features (hidden buttons, disabled buttons and dynamic button label) in the update on my Patreon platform here: www.patreon.com/ExcelForFreelancers Thanks so much for your continued support
Notificación activada... en espera de este fabuloso tutorial. Me encantan los martes porque despierto con un nuevo video tuyo. Thanks so much, I can not wait.
Hey Randy, luv the videos and have for a long time. I am really looking forward to this one. Suggestion for a video - How to use and set up MZ tools - I would luv to code as quick as you and add my own shortcuts
Thank you so very much, I really appreciate that Dino. I will be making some cool updates to this on our Patreon Platform (or TH-cam Members) here: www.patreon.com/ExcelForFreelancers
Oops, You are right, i forgot. I should have demonstrated this. I am going to bring this up on the Patreon update next week. Thanks so much for bringing this up to me. Thank you for your Likes, Shares & Comments. It really helps.
Hello, I'm a follower here from Brazil, I want to congratulate you on the excellent content, I would like to ask a question, how do I create a button that hides and displays all the ribbons, except the ones I created? Thanks in advance.
Hi and thanks very much. I would have to research that, as I am not sure. Please feel free to post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
HI and thanks very much I get most of my icons from the following sites: icons8.com/iconizer/ adioma.com/icons www.iconsdb.com/ Thank you for your Likes, Shares & Comments. It really helps.
That will be Huge Sir, I am wondering if there is a way to Hide the other tabs, and if needed they will be show automaticaly based on certains specific actions. I know that the Entire Ribbon can be Hide, but how about only some specific Tabs.
Yes I believe so. Please check the solutions discussed here: stackoverflow.com/questions/19967283/excel-hide-show-all-tabs-on-ribbon-except-custom-tab I think you are going to love this training. Please set your reminder and share the video. Thank you for your Likes, Shares & Comments. It really helps.
Thank you for all this information. I loved what I learned in this video. What does your login/logout button actually login to? I am just very curious. Is it tied to the person specifically logged in to the computer, recording their changes in the workbook? Could a workbook similar to this track hour by hour numbers from a production line and be able to show real-time information? I am genuinely intrigued by all this. I had a coworker help with a workbook to auto populate cells, but now I want to try more. .
HI and thanks so much. In this training, the Login/Out button is just tied to a cell value, however you can incorporate this feature into a full user security workbook like this: th-cam.com/video/0ahYoy5L3ec/w-d-xo.html To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks for your comment Peter. You can specify a single column of the table for the list or use Named ranges. Both will work however I find named ranges a bit more customizable and recognizable within the VBA code. Thank you for your Likes, Shares & Comments. It really helps.
love this video I've been looking for something like this for a long time, is there a way to set the new ribbon to default so it is selected when I open the workbook.
Hi and thanks so much. I had not tried this but its a good question. I think i found a solution here: stackoverflow.com/questions/21139173/activate-a-particular-ribbon-tab I also added 3 additional features (hidden buttons, disabled buttons and dynamic button label) in the update on my Patreon platform here: www.patreon.com/ExcelForFreelancers Thanks so much for your continued support
Tried to download this workbook several times. Even used a second email account. I am getting the confirmation page that says to check the email from Excel for Freelancers but I am not getting anything. The primary email was used to download another workbook just earlier today so I do not understand why nothing is being sent. All looks normal and there is nothing in SPAM folder.
Hi Malcolm, sorry to hear about the issue with the download. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: th-cam.com/video/ScUBSfEqcrY/w-d-xo.html
Hi Sir. Please I need your help. I watched one of your videos on how to copy and install date picker, you made the video 5years, the installation was successful but each time I opens my workbook, a dialogue box always says," this workbook contains links to one or more external sources..... If you trust the links, update them to get the lastest data...." I have tried updating but it's not working, the dialogue box keeps popping up
Hi , Thanks for your comment. Please unhide the hidden sheet 'Pop up Calendar' and check for any links in the shapes or in formulas on that sheet. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
![Create Horizontal AND Vertical Tabs in this Excel Employee Manager [Part 1]](http://i.ytimg.com/vi/iyr9WIyxlJc/mqdefault.jpg)
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
there are thousands of people posting
excel videos but this guy really stands out, he can do amazing things!
To tell the truth it's a bit complicated for me, both for the project itself and for understanding the language... But, the little I understand, is enough to amaze me every time... Keep it up bro!
Thanks for spreading your knowledge!
Thank you so very much, I really appreciate that Frank. I am so glad you enjoy the content and I am sure you will enjoy this video training. This one is a bit simpler and I write the code from scratch during the training
Hi Randy - a few months ago I spent a couple of weeks trying to design a custom ribbon toolbar, watched dozens of videos from other creators and ultimately was able to cobble it together. Your video is the perfect tutorial with everything needed all in one place!
Many thanks for your teachings and for sharing your knowledge!
Fantastic!. I am really happy to hear that and so glad to help and share. Thank you for your Likes, Shares & Comments. It really helps.
Great tutorial, Randy! I’ve wanted to implement ribbons in my Excel apps for several years & have watched many YT tutorials & read many blogs, but none laid it out clearly enough for me to move ahead. This tutorial is, by far, the best I’ve viewed on this subject. Clear, detailed explanations with many examples, including complex logic, that will enable me to start using custom ribbons in my apps. Finally! Thank you!
Awesome Jim, thanks so very much. I really appreciate that. I also added 3 additional features (hidden buttons, disabled buttons and dynamic button label) in the update on my Patreon platform here: www.patreon.com/ExcelForFreelancers
Thanks so much for your continued support
Reminder set, can't wait for this one Randy. Amazing
Great, thanks so much. This one is not too long and we do it all from scratch. I am sure you are going to love it.
I was looking for this type of videos, and you showed us really easy and fast. Thanks for this video, Keep it up.
Great, thanks so much. I am glad to help and share
Notificación activada... en espera de este fabuloso tutorial. Me encantan los martes porque despierto con un nuevo video tuyo. Thanks so much, I can not wait.
Thank you so very much, I really appreciate that and I am sure you will love this training
This an incredible work ! Just amazing
Thanks so much Adam. I am so glad you enjoyed it
Hey Randy, luv the videos and have for a long time. I am really looking forward to this one. Suggestion for a video - How to use and set up MZ tools - I would luv to code as quick as you and add my own shortcuts
THanks so much Peter. I will check it out. Thank you for your Likes, Shares & Comments. It really helps.
As usual, very helpful training material, Thanks so much for sharing.
For sure, you are very welcome and happy to help and share.
Thank you for your Likes, Shares & Comments. It really helps.
Fantastic Randy, loved this one.
Thank you so very much Graham. I am glad you liked it.
Thank you for your Likes, Shares & Comments. It really helps.
It's so much valuable. Thank you!
For sure, you are very welcome and I am happy to help
Thank you so much, Mr. Randy...
For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.
Thanks Randy for this amazing video.
For sure, you are very welcome Syed. Thanks for your continued support
this is beyond amazing, thank you.
this guide was really clear and easy to follow, even for a noobie like me
Thank you so very much, I really appreciate that Dino. I will be making some cool updates to this on our Patreon Platform (or TH-cam Members) here: www.patreon.com/ExcelForFreelancers
Very clear instructions 👍!
Quick question though, why don't you use the feature "Generate Callbacks" from the tool "RibbonX Editor" ?
Oops, You are right, i forgot. I should have demonstrated this. I am going to bring this up on the Patreon update next week. Thanks so much for bringing this up to me.
Thank you for your Likes, Shares & Comments. It really helps.
Randy sir thank you so thank you so much...
You are very welcome and thanks so much
I am waiting 🙌
Great, thanks very much @cabbaaz :)
Hello, I'm a follower here from Brazil,
I want to congratulate you on the excellent content, I would like to ask a question, how do I create a button that hides and displays all the ribbons, except the ones I created?
Thanks in advance.
Hi and thanks very much. I would have to research that, as I am not sure. Please feel free to post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
you are excellent teacher
Thank you so very much, I really appreciate that
@@ExcelForFreelancers how download
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Thanks for your video
I have a question where do you find your icons or how do you create it ?
thanks
HI and thanks very much I get most of my icons from the following sites:
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers thank you
Eagerly waiting sir
Great, thanks so much. I am happy to help and share
That will be Huge Sir, I am wondering if there is a way to Hide the other tabs, and if needed they will be show automaticaly based on certains specific actions.
I know that the Entire Ribbon can be Hide, but how about only some specific Tabs.
Yes I believe so. Please check the solutions discussed here:
stackoverflow.com/questions/19967283/excel-hide-show-all-tabs-on-ribbon-except-custom-tab
I think you are going to love this training. Please set your reminder and share the video. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thank you Sir, I'll take a look at.
Thank you for all this information. I loved what I learned in this video.
What does your login/logout button actually login to? I am just very curious. Is it tied to the person specifically logged in to the computer, recording their changes in the workbook?
Could a workbook similar to this track hour by hour numbers from a production line and be able to show real-time information?
I am genuinely intrigued by all this. I had a coworker help with a workbook to auto populate cells, but now I want to try more. .
HI and thanks so much. In this training, the Login/Out button is just tied to a cell value, however you can incorporate this feature into a full user security workbook like this: th-cam.com/video/0ahYoy5L3ec/w-d-xo.html
To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html
I hope this helps and thanks so much.
Hi Randy, lol, using my favorite line, it's a secret don't tell anyone 😅😅😅
Haha yes for sure. Please keep it a secret :) :)
Hi Randy - for the drop down lists can you use table for the list then named range in the code?
Hi and thanks for your comment Peter. You can specify a single column of the table for the list or use Named ranges. Both will work however I find named ranges a bit more customizable and recognizable within the VBA code.
Thank you for your Likes, Shares & Comments. It really helps.
love this video I've been looking for something like this for a long time, is there a way to set the new ribbon to default so it is selected when I open the workbook.
Hi and thanks so much. I had not tried this but its a good question. I think i found a solution here:
stackoverflow.com/questions/21139173/activate-a-particular-ribbon-tab
I also added 3 additional features (hidden buttons, disabled buttons and dynamic button label) in the update on my Patreon platform here: www.patreon.com/ExcelForFreelancers
Thanks so much for your continued support
Hi Randy, thanks for the wonderful video.
How do I make cell value = application caller
or cellvalue = msgbox prompt value
HI and thank you could do something like 'Sheet1.Range("A1").value = Application.caller
I hope this helps and thanks so much.
Waiting
Thanks so much. I am sure you will love it
What version office you used sir ? 365 or professional plus 2021 ?
Hi and thanks very much. I am using Desktop 365, however this Custom Ribbon Toolbar will work in any version.
I hope this helps and thanks so much.
Sir I have one mquestion addition to upcoming topic can we make chatbot in microsoft excel for example to do the spend analysis
Hi and thanks very much. Yes for sure. I have it here bit.ly/AIToolpack_RandyShared
I hope this helps and thanks so much.
Tried to download this workbook several times. Even used a second email account. I am getting the confirmation page that says to check the email from Excel for Freelancers but I am not getting anything. The primary email was used to download another workbook just earlier today so I do not understand why nothing is being sent. All looks normal and there is nothing in SPAM folder.
Hi Malcolm, sorry to hear about the issue with the download. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hello ,
How to extract and export a specific file (in Pdf or Fdf format) from WhatsApp groups in an easy and free way with Vba Excel ?
Hi and thanks for your comment. I have not tried that so I am really not sure. Thank you for your Likes, Shares & Comments. It really helps.
Hello! I am very happy to share the news that I have created this training for you and it will be premiered this Tuesday September 12th. Please make sure to Like & Share it here: th-cam.com/video/ScUBSfEqcrY/w-d-xo.html
Hi Sir. Please I need your help. I watched one of your videos on how to copy and install date picker, you made the video 5years, the installation was successful but each time I opens my workbook, a dialogue box always says," this workbook contains links to one or more external sources..... If you trust the links, update them to get the lastest data...." I have tried updating but it's not working, the dialogue box keeps popping up
Hi , Thanks for your comment. Please unhide the hidden sheet 'Pop up Calendar' and check for any links in the shapes or in formulas on that sheet. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers okay sir.
Thank you 💞
Our company uses Windows 11. The RibbonX Editor will not work on Windows 11. Not yet. Been waiting for an update.
Hi and thanks you can check for an update on this.. Just search RibbonX Editor for Windows 11
I hope this helps and thanks so much.