How To Create a Slide Out Menu In Microsoft Excel
Vložit
- čas přidán 1. 08. 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN CZcams MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to easily create your own slide-out menu in Excel.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/SlideOutMenu_DL
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:18 - Overview
5:11 - Mouse Move
9:25 - Slide Out Contacts
10:44 - Slide-In Contacts
15:52 - Click Email
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #slideoutmenu #excelmenu #microsoftexcel - Jak na to + styl
![Responsive Sidebar Menu in Excel [Side Navigation Bar for Dashboards]](http://i.ytimg.com/vi/T6pRSAZXKpQ/mqdefault.jpg)
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
You take Excel to a whole new level each time. Excellent as always.
Thanks so much, very kind of you.
This is why MS gives you rewards, Mr. Randy ... you deserve them
Thank you so very much, I really appreciate that Kendethar. :)
Hey Randy, you never stop amazing me! For real, you have creativity and are really good at what you are doing.
Keep it up!
Thanks so much. I really do appreciate that. :)
Brilliant. Thanks for this helpful video
For sure you are very welcome
A very clever application to make a professional page, congratulations.
Thanks so much Omar, I am really glad you liked it.
Your tutorials are unprecedented.
Thank you so much K D. I am really glad you enjoyed it.
Great job🎉❤
Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤
HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Wow Randy it's amazing and brilliant I too excited
Thank you very much. I do appreciate that.
Awesome Mr Randy. !!!
Thank you very much. I do appreciate that Edward
Amazing One Bro...
Thanks so much :)
Coz I loved the way you make the videos and you explain it
Thanks very much. I do appreciate that.
Great job...
Thanks so much. I do appreciate that.
Thanks so much
For sure you are very welcome. :)
awesome buddy
Thanks so much
WOW thanks bro
For sure you are very welcome.
Wonderful
Thanks so much. I'm glad you like it.
Fantastic ...
Thanks very much :)
wow you are amazing bro :), love your videos.
Your sheets always look amazing and professional. How do you theme/color your sheets so beautifully like that ??
Btw, ever thought of extending solutions to *Access* ? i am positive you can do exceptionally hilarious stuff with the power of Access
Hi thanks so much. I am really glad you like them. I will be having some comprehensive courses coming out soon.
Access I used to do, and might get back into it sometime in the future. Much appreciated.
Excel For Freelancers Unfortunately, Access isn’t used much in the corporate world and most are just using excel and power bi.
Good video
Thank you for your Likes, Shares & Comments. It really helps.
Good job Randy I Like you
Thank you so much Muhamad. I am really glad you enjoyed it.
Nice
Thank you so very much, I really appreciate that.
Good video ❤️❤️❤️
Glad you enjoyed. Thank you Rofiqul
You should start one more playlist for basic VB tutorials...
I can of course, and would like to, but there are some really good ones, such as VBA Is Fun. I was trying to create something different. What do you think?
amazing! and it works very well for me.
but is there a way to prevent the menu buttons from disappearing when i have to scroll down the sheet?
can you fix the menu in place?
Hi and thanks Micha, while there is no way to fix a shape you can have a shape appear again as your scroll down.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Randy,
thanks for the great tutorial! I am trying to implement your solution to my project, but sadly I have some trouble with the ActiveX Labels: They always get in the way when I try to activate a macro attached to the graphical elements: The label will become visible and white on click. Any idea what I am doing wrong?
Keep up the great work!
Hi Malo, this may happen for a split second however you can turn off screen updating temporarily to minimize this effect. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
you know you can add a DoEvents to each of those slide macros to have it actually appear animated. put inside those For loops. either at the beginning of the for loop or the end of the for loop will work
Thank you for your Likes, Shares & Comments. It really helps CoderzF1
I am sorry... Really I forget to appreciate your efforts. anyway so thanks. I love this tutorial send me more
Thanks again
Thank you so much Mohamad, I am so glad you like this tutorial. I have now 70 on my channel and I hope you can view and enjoy many of them. We are now creating an amazing Employee Manager, so please check out our current videos. Thanks again.
Would you share the website with all of the icons you mentioned in your video?
Hi sure, this is one of my favorites: icons8.com/iconizer/
Hey Randy...Love your work..you make it all look so easy..question..I'm running Office 365 for mac and don't have the insert menu on my developer tab..will this only for Windows? Is there a work around for mac?
Hi Doreen, thanks for your comment. I have not spent enough time on a Mac for Excel to offer you much help at this point (I will be taking time to get better at Mac's very soon), however Ron DeBruin has some great Mac tips here. I hope this helps: www.rondebruin.nl/mac.htm
Otherwise we also have an amazing group of experts in which I am sure you can get answers here: Excel For Freelancers Facebook Group here: bit.ly/groupexcel
This info might help, though it's not for Office 365:
answers.microsoft.com/en-us/msoffice/forum/all/missing-design-mode-in-my-develop-tab-ms-office/6fc68fad-e6dc-45b2-9d89-512b0d6ee059
Amazing excell, just not for data
That is right. Thank yo so very much.
Greetings Randy,
Great video as always, thanks for sharing it!
I was able to replicate everything except when I activate the slide in macro, the shape returns back to its original size, but it remained at the position it extended to when the slide out macro was enabled.
--- Original Size and position
------------ After Slide out macro
--- After Slide In macro
I hope you have a solution for this.
Thanks in advance!
HI and thanks very much. You can play with the properties "Size but don't move with cells" or "Don't Move or Size with cells" based on the location of your menu, one of these options should solve your issue. If not you can also set the Left positional based on a certain column within VBA,
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
This video is so amazing, thank you. But tried to follow hyperlink event on this on a hidden sheet but cant do it.. Kindly please aid/advise, appreciated in advance..
Hi Mike thanks so much. This technique does not use hyperlinks however you want to use the Activate command within a macro to display the sheets. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
very useful video, but the link provided in the description just input email address. nothing came in my email. Please help.
Hi thanks for your message. Perhaps it went to spam. Please reach me on facebook here so I can send you your download: m.me/ExcelForFreelancers?ref=Welcome%20message
Would it still work if you group the icon and the button?
It should however you may have to ungroup to change the individual size of the buttons. Certainly worth a try
Really amazing vedio Sir... very useful... Sir I have a question.. if we will create shapes instead of commond buttons in excel worksheet.. how the shape will change its back color on mouse move.. please help.. and send a code.
Hi thanks very much for your comment. The buttons I use are also shapes so you would just have to change the shape fill property. You can run a macro to see how this is done, then modify your code accordingly. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@@ExcelForFreelancers Hi, Thanks again... Sir, it would be your great favour if you give me some idea for a such fill properties.. or give a hint to write a code... thanks in advance..
Hi thanks i am unable to here, but if you post your question in our facebook group we have 14,000 Experts who can help you.
what video you have that explain this from the beginning?
HI this is the only video I have on slide out menu's. Some videos in the past I did not start from the beginning but all of my newer videos I generally start from scratch. Thanks for your comment.
Do you know of a way to prevent the label color from changing when it is clicked?
Actually just thought of a good fix. You can have the add the following to the hover label _mousemove and _click:
Me. HoverLabel.Visible = false
Me.MinAll.Visible = true
And for the minAll you can add the opposite
HI and yes you can just keep the initial font color of the shape. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy. I am doing some coding using Excel 2019. I have run into a particular compiling error. The example is "Filename = ThisWorkbook.path & "\Database.xlsm"
, with the compile problem relating to the semi-colon, in this case at the end of "&". Are you able to identify a solution please? I have experienced the very same problem with the similar coding that includes a semi-colon in one of your other applications. Otherwise I am learning something new from your Excel applications everyday. Thanks heaps
Hi Stephan, If you are on a PC (not a Mac) the path should be Filename = ThisWorkbook.path & "\Database.xlsm"
If you are on a Mac then the file path is different and you can learn more about that here: www.rondebruin.nl/mac/section3.htm
Thanks so much for your comment.
Thank you for the information. I use a PC. While I did not associate the particular coding with Excel on a Mac, I was eventually able to work out "amp" probably related to "ampersand" - hence "&". By removing the word "amp", I was quickly able to eliminate the compiling error. Thank you again. Onto the next challenge!
Glad you got it to work. Yes "amp" should not be there which is why i also removed it in my code to you above.
12:48 - VBA for moving icon
Hi, thanks for your comment at the 12:48 Mark, that macro describes how to move the icon. you can download the free workbook with the links above to try it yourself.
Can't download the workbook using the link provided in the description..it is showing 403 forbidden error..pls provide a valid link
Hi Thanks we were upgrading out servers, but should be working great now.
What is the link to the icon website?
Hi here you go: icons8.com/iconizer/
when I Move Down mouse in lable navigation then lable not transparent,. it back color. can you fix it?
HI this is not something that can be changed as it is part of Excel. Thanks very much for your comment. Cam on ban.
Hello, It seems like I got just about everything to slide in and out, but for some strange reason I have to hover the mouse about two cells up/down from the Icon to get the desired affect. Anyone have any suggestions? Thank you,
Hi Eugene, thanks for your comment. The hover should work regardless of the cell its over. You will want to make sure the shape control is big enough so that the mouse hover is over the top of it and also make sure the shape control that hides it, is out of the way a bit. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
Master hi, when i click your slide menu open your the website.I wanna page link( sheet 1, sheet2 etc...)your slide menu. I tried but i couldn't. Could you please help me.Thanks in advance
Hi and thanks if you want to use a macro you can use a single line of code like this
Sheet1.Actviate
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers Thanks yo so much master. I done👏👏👏😊
Its just for me that some icons change size? I changed the size of the rectangles ...
Hi Igor, thanks for your comment. Make sure in the shape properties options you set them to "Move but don't size" this way they won't change their size. I hope this helps and thanks so much.
I downloaded the file it looks awesome by the way, however, when I move the cursor from one icon to another, it does not pop out right away or it pops out when I move to the next. The only way I found to get it to work properly is by reducing the "MinAll" square, but then I have to move the cursor out of the square and then back in, in order for it to minimize the popped out button, is there any way to fix this in the code?? Am I the only one experiencing this?
Hi Javier thanks for your comment. The solution would be to make sure there is enough spacing between the button so the user has time to hover over and open/close the menu. You can also write code to close the menus on selection change of any cell in the sheet. I hope this helps and thanks.
2 things: 1) Your "hover" shapes are too large and are overlapping each other causing the code to operate erratically. Go into Designer Mode, open the Selection Pane and select one of the Hover shapes, resize it so it is the exact same width as the button it is associated with when the button is extracted (largest size) but only as tall as the button. 2) In the Selection Pane move that Hover shape in the list so it is below the button and icon it is associated with. Do these 2 things with the remaining Hover shapes. I placed all of my hover shapes at the bottom of the list in my Selection Pane. Make sure the MinAll shape is all the way at the very bottom of the list in the Selection Pane. Turn off Designer Mode. Enjoy!
can you share this file please
For sure, the link for download is about in the description, but i will also add it here: Download the FREE Workbook and follow along here: bit.ly/SlideOutMenu_DL
My excel, don't have mouseMove option.. Why it happen sir??
Hi and thanks make sure you are using Excel on a PC so you get the full functionality. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers Hye sir.. I already requested for that group.. Please accept me.. I mean PLEASEEEEEE 😂 🤣 😂 🤣.. Btw, the answer is not solve my problem sir.. Bcoz I'm already using Excel in my office PC.. 😂
Hi and thanks if you have not yet received admittance into the group please email angeli@ExcelForFreelancers.com and supply your email and fb id link so that they can help you with that. Thanks very much.
the slides are not responsive with the latest office 365 Excel edition. so it's not usefull.
The browser based Office 365 does not handle macros. You would want to use any Excel Application that allows for macros.
Thanks for your comment.
it's not on the browser based excel, i use the standalone desktop version and allow the macro's.
erendiz79 If macros are enabled I'm not sure what the issue could be. Unfortunately I don't have that version I could test on. Perhaps someone in our Excel for Freelancers Group could shed some light on it if you post the question. bit.ly/groupexcel
I'm not understanding your vba
Hi thanks for your comment. Some videos are more advanced then others. This one is a bit more advanced.
link is click bait just to capture your email thats so not kool after a nice video... been two days now and no workbook thats BS
Hi for sure it is not click bait. Sometimes emails go to spam so that can happen. I also offer facebook messages in which you can download the workbook directly from your messenger on most newer videos. Please download the file directly from this link (no email required) here: bit.ly/SlideOutMenu_WkBk
I can assure you that I do want to get this workbook in your hands. Thanks for your patience and please feel free to email me should you have any questions Randy@ExcelForFreelancers.com
No it is not click bait. I have just downloaded it and it works as shown in this video.
I didn't received it after few hours now :(
Great job🎉❤
Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤
HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Nice
Thank you very much. I do appreciate that.