ðĨ GET 350 OF THE WORLDS BEST EXCEL TEMPLATES: https://rebrand.ly/350Wkbks_YTDesc
ð NO MORE MISSED APPOINTMENTS WITH EXCEL CALENDAR PRO ð https://rebrand.ly/CalendarPro_YTDesc
ð GET A DISCOUNTED DEVELOPERS LIBRARY HERE âš https://rebrand.ly/UDVL_YTDesc
ðĪBRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN âš https://rebrand.ly/AIToolpack_YTDesc
ðCREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM âš https://rebrand.ly/MentorshipProgram_YTDesc
âķïļ GET ACCESS TO OVER 150 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: https://rebrand.ly/Patreon_YTDesc
ðĻâðžBECOME AN EXPERT AT DASHBOARDS âš https://rebrand.ly/ExcelDashboard_YTDesc
ðĢSTART LEARNING VBA HERE âš https://rebrand.ly/VBAEFFDan_YTDesc
ðBECOME A SUCCESSFUL FREELANCER âš https://rebrand.ly/FreelancersAcademy_YTDesc
âïļJOIN YOUTUBE MEMBERS FOR UNRELEASED TRAININGS âš https://rebrand.ly/YTMembership_YTDesc
In this training, I introduce the User Security and Rights Excel Add-in, which lets you assign multiple security levels to any worksheet in just a few clicks. You’ll learn how to manage users, set security levels, and protect worksheets across any workbook. This step-by-step guide covers everything from user logins to customizing worksheet permissions. Donât forget to like, subscribe, and download your free add-in to follow along!
âŽDOWNLOAD THIS WEEK’S WORKBOOK TEMPLATE HERE:
This Excel Add-In Solves User Security Issues PERMANENTLY + FREE DOWNLOAD
EXCEL COURSES:
âšMENTORSHIP PROGRAM: https://rebrand.ly/MentorshipProgram_YTDesc
âšDASHBOARD MASTERCLASS: https://rebrand.ly/ExcelDashboard_YTDesc
âšBEGINNERS VBA COURSE: https://rebrand.ly/VBAEFFDan_YTDesc
âšFREELANCER ACADEMY: https://rebrand.ly/FreelancersAcademy_YTDesc
âšWEB AUTOMATION COURSE WITH EXCEL VBA: https://rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
âšThe Ultimate Schedule Organization with Excel Calendar Pro: https://rebrand.ly/CalendarPro_YTDesc
âšGet 350 Templates In 1 Zip File: https://rebrand.ly/350Wkbks_YTDesc
âšGet 500 Done-For-You Macros: https://rebrand.ly/UDVL_YTDesc
âšGet ChatGPT Into Excel With This Addin: https://rebrand.ly/AIToolpack_YTDesc
âšThe Ultimate Excel Resource Guide: https://rebrand.ly/UERG_YTDesc
âšGet Your Actual Employee Hourly Cost: https://rebrand.ly/LBC_YTDesc
âš1000 Incredible Freelancing Resources: https://rebrand.ly/UFRG_YTDesc
ð§Find the Best Excel Products & Courses Here: https://rebrand.ly/ExcelProductsAndCourses
Timestamps:
0:00 â Introduction
1:20 â Overview
37:34 â Initialize Userform
48:40 â Change SelWkbk
53:30 â Refresh Tree View
1:02:00 â User Load
1:05:32 â Login Out Form Show
JOIN OUR COMMUNITY: https://rebrand.ly/EFF_Group
Follow me on my Social Media Accounts:
ðĪĐTikTok: https://www.tiktok.com/@excel4freelancers
âïļX: https://x.com/Excel4Freelance
ðWebsite: https://www.ExcelForFreelancers.com
ðLinkedIn: https://www.linkedin.com/in/excelforfreelancers/
ðĪFacebook: https://www.facebook.com/ExcelForFreelancers/
ðļ Instagram: https://www.instagram.com/excelforfreelancers/
ðĨRumble: https://rumble.com/c/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:
ð https://www.youtube.com/c/ExcelForFreelancers/
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelVBA #ExcelSecurity #ExcelRights #UserSecurityandRights #ExcelAddIn #UserPermissions #ExcelTips #ExcelAutomation #SpreadsheetSecurity #ExcelTraining #ExcelDataProtection
14 Comments
I want to thank you, Randy. I have been building our very own Mechanic Shop system off of your videos and I have learned so much. You make it simple to understand. Before I found you, I had no idea that vba was even a thing. Our shop is very small and you have everything we need! Keep up the great work!
Thanks @Randy for the video,it's useful.
Hi RandyâĪ. Love your videosâĪðð. Can you please please ð add a hospital manager series like the school manager series with many features please âĪ.thank you love from Tanzania, east Africa.
Amazing thank you!
Can multiple people open or work on it at same time?
You are king of excel vba
Persistence & hard work over the years definitely pays off. This is a fantastic Add-in … Thank you Randy
Another Masterpiece from Randy…
Sir i have already typed a comment but it was not showing now.Any problems with my comments sir?
Just curious why my Youtube displays Arabic text when I enable CC. Don't think it is my youtube setup. Anyting in the video uploads that does this setting?
Thank you sir, really you are amazing in Excel. I have a question, Multiple user Can work on office 365 file at same time?
Thank you, Randy. Just a few questions I want to find out. 1. If I did have a sheet in my workbook and I delete it, it still show under my username, how to get rid of it. @. I I add a user and I gave him the workbook, will it work on his computer so he must input userid and password, as I do not give them the xlam file .
I was trying to test this method and have a suggestion. Is there a way to show which user is logged in? Perhaps the user name at the top? Also when testing a particular workbook how can that workbook require a login at startup? Then if the credentials aren't correct the workbook can't be opened.
Hi Randy, can you make when you choose a user, to select more than 1 sheet to do the security part