The AMAZING TRICK To Add Different User Security Rights to ANY Excel Sheet and User Login

Рет қаралды 345,864

Күн бұрын

😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_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 KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create User Login AND apply different security for each sheet.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/UserLogin_WkBk
🤑 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 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_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:30 - Overview
2:06 - Insert Symbols
8:19 - Before Double Click
17:46 - Check User
39:39 - Insert User Form
44:53 - Close Workbook
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 #userlogin #securityrights #usersecurity

Пікірлер: 1 000

@ExcelForFreelancers 2 ай бұрын

🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► rebrand.ly/FreelancersAcademy_YTPinnedCom

@macman007747 3 жыл бұрын

Wow! Your lessons never cease to amaze me Randy! I learned lots of cool stuff from this lesson, not the least of which was the CELL function and how to lock up my VBA code. I am very grateful for your awesome teaching style!

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Rob. Glad you liked the training.

@harrylarmer4295 4 жыл бұрын

Super cool tutorial, thank you very much. The steps are well explained and the context you provide in your commentary is gold.

@ExcelForFreelancers 4 жыл бұрын

Thanks so much Toby, I am really glad you enjoyed the trainnig.

@excel-businessinexcel5181 4 жыл бұрын

You are a very creative person! I myself have long drawn tables and even make programs, but when I saw your work-just opened my mouth in amazement! You don't need to draw tables, but cars!

@ExcelForFreelancers 4 жыл бұрын

Thank you so much. I really appreciate that. I see that you are "Accounting In Excel" so please check out lots of my videos in Accounting I think you will really love.

@binyedeng4430 5 жыл бұрын

The BEST Excel VBA tutorial in KZfaqr ever! Thanks a lot!

@ExcelForFreelancers 5 жыл бұрын

Thank you so much. I really appreciate that Binye. I look forward to creating a lot more videos and training.

@EOO-Stand 4 жыл бұрын

Another great video. I thought I was good at coding until now that through your videos I discover that there is so much you can do and at the same time simplify the codes. I still have a long way to go. btw I like your style of teaching, you are not too fast, the pace is perfect. Thank you for your dedication

@ExcelForFreelancers 4 жыл бұрын

Thanks so much, I am really glad to share some new ideas and new ways of looking at Excel. Thank you.

@Kestra1207 5 жыл бұрын

I absolutely loved this tutorial and followed it all the way through to create the same product for a payroll template at work. I am so excited with the outcome and it works beautifully. TY for your videos. You're a great teacher!

@ExcelForFreelancers 5 жыл бұрын

You are very welcome Monica. Thanks so much for your comment. I am glad I can help and share.

@gayboynz1 6 жыл бұрын

OMG I just spent the last three hours going thru this Step by Step totally helping and awesome. Thank you so much.

@ExcelForFreelancers 6 жыл бұрын

Fantastic. So glad you liked it Adam. Have a look at my other videos and let me know what you think. If you ever need help, please join our Excel For Freelancers Facebook group here: bit.ly/groupexcel

@landgegaile6957 3 жыл бұрын

that was great! no doubt the way you deliver your presentation convinces the viewer from a skillful master. i actually learn a lot from your presentations.

@ExcelForFreelancers 3 жыл бұрын

Thanks so much Landge, I really appreciate that. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries

@ivanbork4175 6 жыл бұрын

I really appreciate the good quality and easy understanding help in your videos; especially I can use this tutorial about user login. It was quite easy to follow, and create a “personalized” file for our use. However, there is one thing that could be very cool to add, if possible. I’m thinking about a counter, that can tell which users have opened the file, and maybe when

@ExcelForFreelancers 6 жыл бұрын

Hi its a great point you make. I am thinking very soon to create a 'Change Log' Application which not only how which users have opened but what changes they have made in the workbook along with an 'Undo Changes' option which would allow a user to reverse the actions made. I think this would be helpful

@moesadr3342 2 жыл бұрын

@@ExcelForFreelancers That would be very much appreciate! Thank you

@Eric-qm4vm Жыл бұрын

Hi did you implement the change log? Thanks so much for sharing your great videos.

@Hildgud 5 жыл бұрын

First of all I'd like to thank you for this amazing guide. Second, is it possible to allow a user to view one sheet but only be able to write (edit) certain rows?

@ExcelForFreelancers 5 жыл бұрын

Hello Johnny, Thanks for your comment. It would be possible just make sure those specific rows are not protected. If they are going to be visible, and protected for other users you could add/remove the protection on these specific cells via 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

@StarChild1602 7 ай бұрын

Thank you so much. I did not even know this was an option in Excel and has really highlighted how much there is to learn - I am definitely considering purchasing your course as your instructions and explanation were clear and concise. I only had one issue with this line of code: If .Cells(UserRow, SheetCol).Value = "Ð" Then - it kept coming up with an error but when I change the previous line from SheetNm = .Cells(4, SheetCol).Value 'SheetNm to SheetNm = .Cells(4, SheetCol).Value 'Sheet Name it fixed it! Thank you once again, it was brilliant :)

@ExcelForFreelancers 7 ай бұрын

Hi and thanks so much for your feedback. I can understand your issue. I did this training many years ago, before I realized the "Ð" character would not work in every regional setting. Now instead, I will use the character equivalent which is Chr(208), so your line would be If .Cells(UserRow, SheetCol).Value = Chr(208) Then I hope this helps and thanks so much.

@ganeshs1360 4 жыл бұрын

The "veryHidden" option was very hidden actually. Never knew it existed at all. Thanks Randy :)

@ExcelForFreelancers 4 жыл бұрын

For sure, you are very welcome Ganesh, I am happy I could help

@aprilshowersmayflowers 6 жыл бұрын

Thanks for the wonderful training. I keep getting an error code here and I've gone over and over it and I cannot find what I did wrong!For SheetCol = 7 To 41 SheetNm = .Cells(3, SheetCol).Value 'Sheet Name If .Cells(UserRow, SheetCol).Value = "Ð" Then Sheets(SheetNm).Unprotect "123" Sheets(SheetNm).Visible = xlSheetVisible End IfCan you help?

@ExcelForFreelancers 6 жыл бұрын

Hi thanks, you can move the ClearContents Line Below the UserRow line like this: LoginForm.Hide UserRow = .Range("B8").Value 'User Row .Range("B5,B6").ClearContents In the download sample I had provided this issue was corrected like the above. 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 with code screenshots here:bit.ly/groupexcel

@aprilshowersmayflowers 6 жыл бұрын

Thank you so much! That worked perfectly! I'm very excited to use this for my team!

@ExcelForFreelancers 6 жыл бұрын

Great I am happy to help

@vickyli3187 Жыл бұрын

Hey April, did you find the solution? I followed every step and checked the code for three times, but still the same problem. I am exhausted

@ExcelForFreelancers Жыл бұрын

@@vickyli3187 HI Vicky, please use Chr(208) instead of "Ð" inside the code. I hope this helps and thanks so much.

@jayateerthkatti7517 4 жыл бұрын

Great man. You are an Uppercut in Knowledge and more above you are sharing knowledge to all.. Best Luck for next Tutorial.

@ExcelForFreelancers 4 жыл бұрын

Thank you very much Jayateerth, I am really glad you liked it.

@9323793901 6 жыл бұрын

one of the best tutorial i have seen and learn something new thanks for sharing your knowledge i have also implemented your this idea in my work and its really worked and helped me

@ExcelForFreelancers 6 жыл бұрын

Wow thanks so much. I just uploaded a new one 5 minutes ago. Have a look and let me know: kzfaq.info/get/bejne/rrWHfaydrJ68dXk.html

@mohammadrashedulislam179 4 жыл бұрын

Debug occurring: If .Cells(UserRow.SheetCol).Value = "Ð" Then can you please share the e-mail id so that I can forward you the attachment sir

@ExcelForFreelancers 4 жыл бұрын

Hi thanks for your message and sorry you are having issues. I have created a Facebook group with 20,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.

@SimonsKitchenUK 4 жыл бұрын

Same here. Did you get a solution? I think I have fixed it!

@nejatbocnak1699 3 жыл бұрын

@@SimonsKitchenUK hello. ı am having same problem. how did u solve it ? thx.

@shashankshekhar1178 3 жыл бұрын

You are an awesome guy, I have learnt a lot from you. You resolve every problem of mine related to excel.

@ExcelForFreelancers 3 жыл бұрын

Thank you so much Shashank, I really do appreciate that.

@janezklun 4 жыл бұрын

Great tutorial, thank you for sharing, Cheers Janez

@ExcelForFreelancers 4 жыл бұрын

Thanks so much. I really appreciate that.

@esapekkaturunen488 3 жыл бұрын

Thank you very much for this. I was positively surprised that it actually works!

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome, I am happy to help

@MAhmad-dr6nz 4 жыл бұрын

Great job Sir, Such a deep and details tutorial, very much helpful in dead.

@ExcelForFreelancers 4 жыл бұрын

For sure, you are very welcome I am glad you liked it.

@adil196 5 жыл бұрын

Your great sir... Thankyou to much for share your excellent experience with us. Thank you again sir.

@ExcelForFreelancers 5 жыл бұрын

For sure, you are very welcome, thanks for your comment Mohd

@danailborisov1969 5 жыл бұрын

I am very pleased and very helpful to me, thank you!

@ExcelForFreelancers 5 жыл бұрын

For sure you are very welcome Danail. I am glad I can help

@hirukarucm1133 2 жыл бұрын

Loved it. Changing it a bit to work with named ranges so it is more dynamic. So I can intergrate it into a huge excel system (Where we should use access for but that would mean me learning access without having the time for it ) Now just a way for live editing without having to manually sync. Co-authoring it will be I guess with editing via desktop app. Hope that works with a intergrated user/password system.

@ExcelForFreelancers 2 жыл бұрын

Great job and glad you enjoyed the video. You can set sync to run on any worksheet change or database change so that it runs in the background whenever users make changes or based on any time interval (In the School manager series I show you how to do this) I hope this helps and thanks so much.

@edsonmartins9573 8 ай бұрын

You sir, are a genus. Born to instruct. Respect.!!

@ExcelForFreelancers 8 ай бұрын

Thank you so very much, I really appreciate that

@maisarah6803 3 жыл бұрын

Thank you for this tutorial ✨ Really helpful 🥺

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome Mai. Happy to help.

@abdullahalklbani7454 2 жыл бұрын

Allow me to thank you wholeheartedly for this very special and wonderful lesson.

@ExcelForFreelancers 2 жыл бұрын

For sure, you are very welcome and thanks.

@damiduran 3 жыл бұрын

this is awesome! thank you so much for this tutorial!

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Damian

@johanschurink7744 6 жыл бұрын

Thank you for this video, I did learn something ;)

@ExcelForFreelancers 6 жыл бұрын

That's great. I am happy to hear that.

@kenthomson9562 6 жыл бұрын

Excellent presentation. Thank you.

@ExcelForFreelancers 6 жыл бұрын

Thank's very much. I appreciate that.

@cecileclarke6585 3 жыл бұрын

Thanks for this video. It is just want I needed!! :)

@ExcelForFreelancers 3 жыл бұрын

Glad it was helpful Cecile, thanks so much.

@Jojosmith342 8 ай бұрын

all thumbs up from the start to the GREATEStT VBA teacher Randy

@ExcelForFreelancers 8 ай бұрын

Thank you so very much, I really appreciate that

@herbertbeukenboom8547 Жыл бұрын

Hi Randy, thank you so much for sharing your very clever approach on how to add user login and security rights to an Excel workbook. I came across your KZfaq video last week and liked it very much. I have downloaded the workbook and have made several changes for improvement. Thanks again for sharing. 👌👌👌 I now need to explore the best option to add the security to existing workbooks. Here is a list of the modifications made/planned: 1. Added a password reset form, where users can change their passwords. 2. Masked all passwords. 3. Changed the VBA to automatically remove the entry under 'All Sheets' when one of the worksheet protection options is changed and is no longer the same as the entry under 'All Sheets'. 4. Modified the original formulas to check for an exact match of the passwords, hence "Password123" in no longer seen as the same as "password123". 5. Expanded on the number of workbooks to be protected to 15 and changed the ranges referenced in the VBA to more dynamic ranges for flexibility in future expansions. 6. Added "Read-only" as a fourth worksheet protection option, visualized by an 'eye', represented by Webdings font letter N and expanded the conditional format to show this symbol in Blue. 7. I am contemplating to add an Excel table for an audit trail of user logins and password resets.

@ExcelForFreelancers Жыл бұрын

Those are some great ideas and for sure its going to be a powerful workbook. If you run into any issues with that feel free to post your questions in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

@MICtheG 10 ай бұрын

Hi Herbert @Herbertbeukenboom8546 Please share your updated template for our benefit. Thank you.

@pendoramariah Жыл бұрын

WOW!! This is what I'm looking for😍

@ExcelForFreelancers Жыл бұрын

Perfect, I am very glad I could help

@CesarPeron 6 жыл бұрын

You're really good, thanks for sharing

@ExcelForFreelancers 6 жыл бұрын

Thanks so much Cesar, much appreciated.

@amitshah8508 6 жыл бұрын

Very detailed explanation. Like it.

@ExcelForFreelancers 6 жыл бұрын

Thanks very much. I am really glad you liked it Amit

@iftakhar_hasan 4 жыл бұрын

Thanks a lot for the tutorial. It helped me a lot.

@ExcelForFreelancers 4 жыл бұрын

For sure, you are very welcome Iftakhar, I am glad I could help

@SM-tz1hc 4 ай бұрын

Thank you Dear Respected Sir. Very wonderful. Very professional.

@ExcelForFreelancers 4 ай бұрын

For sure, you are very welcome and I am happy to help and share

@DVSgolddust 4 жыл бұрын

very nice tuto (as usual) i love the way you used Windingsfont, makes life so easy :) The tip about the VBA password came to late for one of my projects, but then again, learning form own mistakes is a great teacher too :D

@ExcelForFreelancers 4 жыл бұрын

Thank you so much P. I am really glad you liked it and look forward to creating many more for you.

@EOO-Stand 4 жыл бұрын

I agree, never thought of using those. makes the work easier than using controls

@ritugoel2202 5 жыл бұрын

Thank you so much! In BeforeDoubleClick add Cancel = True right after the function As Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True

@ExcelForFreelancers 5 жыл бұрын

Hi Thanks for the comment. Yes that would cancel the current cell, however it depends on what function you are trying to perform. With testing you can achieve the feature you want.

@jeffmartinez262 Жыл бұрын

Great tutorial, and fantastic ideas. I do have one very small suggestion for using the "BeforeDoubleClick" trigger. I like to add "Target.Offset(1).Select", or "Target.Offset(0, 1).Select" in the Sub, that way the cell you double-click does not become active, with the cursor flashing at the end of the character string. I personally find that annoying, so adding that simple line can help a lot. Thanks for the video.

@ExcelForFreelancers Жыл бұрын

HI and thanks yes that is a great suggestion. In my recent videos I have also added the selection of another cell when I use checkboxes or some single cell selection function. Thank you for your Likes, Shares & Comments. It really helps.

@TRC00020 3 жыл бұрын

Perfect , excellent video

@ExcelForFreelancers 3 жыл бұрын

Thank you very much Thomas.

@tarot..by..kobkeepintouch 3 жыл бұрын

You are a remember image of excel, Thank you very much

@ExcelForFreelancers 3 жыл бұрын

You are welcome. I am happy to help. Kap Khun Ma Krub.

@SyedMuzammilMahasanShahi 6 жыл бұрын

Thanks for this wonderful video

@ExcelForFreelancers 4 жыл бұрын

Thanks so much

@mariusmatei4562 3 жыл бұрын

Thanks a lot for this video!!!

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome I am happy to help

@dhanunjayab3404 6 жыл бұрын

Very simple formulas and simple code but very good usage

@ExcelForFreelancers 6 жыл бұрын

Thanks very much. I appreciate that.

@muralidharan9576 3 жыл бұрын

VERY USEFUL TUTORIAL...

@ExcelForFreelancers 3 жыл бұрын

Glad you think so and thanks so much Murali, Thank you for your Likes, Shares & Comments. It really helps.

@saidyahya7343 3 жыл бұрын

Someone from India tried to recreate this without credit. Follows will follow, leader will lead... You're very right sir.

@ExcelForFreelancers 3 жыл бұрын

Yes i saw that and KZfaq usually removes them. Thank you for your comment and I appreciate that.

@shadricksiame5741 6 жыл бұрын

this is very nice ...keep it up we need this..

@ExcelForFreelancers 6 жыл бұрын

Thank you very much. I am quite happy to help.

@ulquiorra3504 3 жыл бұрын

Thank you so much.

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome

@learncomputer7725 4 жыл бұрын

You are brilliant sir

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that.

@ezkul95828 3 жыл бұрын

Great coding tutorial. I enjoy watching. As programmer point of view, I would be much better if this code follow coding standard and structure. Thanks for sharing.

@ExcelForFreelancers 3 жыл бұрын

Thanks so much Steve. I really do appreciate that.

@ijnmpi 3 жыл бұрын

Thanks a lot buddy! it helped :)

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome Ketan

@hossammostafa649 Ай бұрын

After 6 years it's still awesome... Absolutely love it.. i never thought that it could happen... I only have one question... If i need to share the file and make everything work on another device how can i do that ?

@ExcelForFreelancers Ай бұрын

HI and thanks so much, I am glad you loved the video. To share and sync your macro-enabled Excel workbook, please watch this training: kzfaq.info/get/bejne/nMVhe9aDnpmUZX0.html

@ahmaddin7565 2 жыл бұрын

Amazing Boss for this User Login & Security Rights Training. I need one more thing in this sheet that if we share this sheet on drive with multiple user with user rights and at one time 2 or 3 user work on the sheet how they can access at same time and save their work. Thank you

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks so much. You can have multiple people work on your macro-enabled workbook using the techniques I teach in this video: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html I hope this helps and thanks so much.

@sijusivan77 3 жыл бұрын

YOU ARE AMAZING ❤️

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Siju.

@-mahmoudfekry1174 5 жыл бұрын

Thank you very much for the valuable information about Excel VBA :)

@ExcelForFreelancers 5 жыл бұрын

For sure, you are very welcome, I am happy to create and share these.

@-mahmoudfekry1174 5 жыл бұрын

@@ExcelForFreelancers Yes Video was shared via Facebook, Twitter and KZfaq :)

@ExcelForFreelancers 5 жыл бұрын

Thank so much. I do appreciate that.

@-mahmoudfekry1174 5 жыл бұрын

@@ExcelForFreelancers I have a question in worksheet (1) in the data and I want to delete the repeated data in the rest of the other work papers by vba code How do I do this?

@ExcelForFreelancers 5 жыл бұрын

Hi thanks you can use a few different filtering techniques including advanced filter. 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

@tramnguyenlequynh5702 4 жыл бұрын

excellent design & coding.

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that Khoi. Cam on em :)

@AnwarHossain-ro2sp 6 жыл бұрын

It is really awesome....

@ExcelForFreelancers 6 жыл бұрын

Thanks so much. I do appreciate that. :)

@adriantoma9796 6 жыл бұрын

I used one trick to make clicks nicer (to avoid entering edit mode). I change the range to a cell, like E4 and next i Return to the same cell. PS: Very good tutorial as usually!

@ExcelForFreelancers 6 жыл бұрын

Hi that's a great idea. good going, and thanks very much for the compliment. Glad you enjoy the videos.

@thecopycats9395 11 ай бұрын

Hi how can i add this

@OlanGuil 4 жыл бұрын

Thanks you so much

@ExcelForFreelancers 4 жыл бұрын

For sure, you are very welcome

@VoVietToan 6 жыл бұрын

thank you Randy

@ExcelForFreelancers 6 жыл бұрын

For sure, you are very welcome. cảm ơn

@seoagencybd 5 жыл бұрын

really Amazing Sir,

@ExcelForFreelancers 5 жыл бұрын

Thank you so much. I am glad you like it.

@joecrack5583 4 жыл бұрын

Thank you so much Randy for this tutorial. Please can you make security features for a file to become undeletable i.e user unable to delete or kill excel file or any other file? Thank you once more as we keep learning from you.

@ExcelForFreelancers 4 жыл бұрын

Hi Joe, thanks very much for your comment and glad you like the videos. your idea of making a file unable to be deleted would have to do more with computer and user rights then Excel, since only file structure rights of a computer can protect files. Using a backup folder such as DropBox ensures that there is always a backup copy of an application should the file be deleted. Thanks so much.

@JBangit 5 жыл бұрын

Brilliant!

@ExcelForFreelancers 5 жыл бұрын

Thanks so much Jayson, I am really glad you like it.

@nejatbocnak1699 3 жыл бұрын

I can not tell you my appreciation with words. All the best. Thank you very much.

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Nejat

@nejatbocnak1699 3 жыл бұрын

@@ExcelForFreelancers It seems that dropdown lists are not working after used your perfect sharing. Do you have any kind solution to overcome the issue? I may do something wrong ! Thx.

@ExcelForFreelancers 3 жыл бұрын

HI and thanks, make sure you check the data validation and the named ranges are accurate. 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

@nejatbocnak1699 3 жыл бұрын

@@ExcelForFreelancers First of all thank you for the prompt return. I checked data validation and the name ranges but could not solve yet. joined the fcb group. and I wrote so. Thx.

@nejatbocnak1699 3 жыл бұрын

@@ExcelForFreelancers ı wrote my issue fcb group, but no return so far. do you have any other solution for me? thx. a lot.

@mdfahimmontasir8755 2 жыл бұрын

Thanks 👍

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that :)

@SapLearning1.0 3 жыл бұрын

Very useful

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Raju

@N7eptune 6 жыл бұрын

Cycling through Blank as well as the Webdings for the cell icons may be a good idea.

@ExcelForFreelancers 6 жыл бұрын

Great point, Thanks so much for your input

@tarasolutions3128 6 жыл бұрын

kzfaq.info/get/bejne/h9GjgdqKudKmiI0.html

@justiceakoi4083 6 жыл бұрын

Thanks for the reply. Any tutorial on School Management system or employee management system

@ExcelForFreelancers 6 жыл бұрын

Hi thanks for your comments. I currently don't have any solutions for school management however for Employees, my latest video shows a Payroll Manager & HTML Email feature that you might be interested in here: kzfaq.info/get/bejne/hdF9ZJuFqZfKdH0.html

@tunaungkyu9828 5 жыл бұрын

Thank you Sir

@ExcelForFreelancers 5 жыл бұрын

For sure, you are very welcome Tun

@pjferreira54 4 жыл бұрын

Thank you for making your knowledge available I would like to ask a question. in this workbook if you have a user I have to hide a column. how to proceed.

@ExcelForFreelancers 4 жыл бұрын

Hi thanks you can hide any column based on a specific user, perhaps something like this. If username = "testuser" then sheet1.Range("A1").entirecolumn.hidden = True. 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

@yurd563 6 жыл бұрын

Thanks, for videounit

@ExcelForFreelancers 6 жыл бұрын

Happy to make them for you.

@Todotienesolucion8370 6 жыл бұрын

Excellent channel

@ExcelForFreelancers 6 жыл бұрын

Thanks so much. I do appreciate that.

@johnadam7996 6 жыл бұрын

Thank you for the great tutorial. I have one question. How do i get the user form to link in MS Office 2011 for Mac as control source is not available?

@ExcelForFreelancers 6 жыл бұрын

Hi thanks very much for the comment. I am not an expert on Mac however If you search for 'Ron DeBruin' his website has tons of great info for Excel with Mac. Thank you

@JonathanExcels 4 жыл бұрын

someone probably pointed this out already but Dim UserRow, SheetCol as Long results in UserRow being a variant data type. you have to explicitly assign a type to each variable. Dim UserRow as Long, SheetCol as Long

@ExcelForFreelancers 4 жыл бұрын

Hi Jonathan, yes and thanks. All of my recent videos for the last year have them Dim'd specifically for each one instead of a general. (See some of my more recent videos to see the updates) Thanks so much for the feedback.

@sorolvision7986 2 жыл бұрын

Nice video good video.

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Sorol

@informationetc4008 9 ай бұрын

This great..❤

@ExcelForFreelancers 9 ай бұрын

Thanks so much and I am so glad you like it

@rabnesbit8287 2 жыл бұрын

Hello. Very detailed tutorial, many thanks!. Just wondered if you are able to do one that uses users usernames on a network, so that there is no need for the workbook to request for logon details, but will just open but display/restrict worksheets according to the rights assigned to that particular username?

@ExcelForFreelancers 2 жыл бұрын

Hi Rab, thanks for your comment, yes you can share any data on a network as long as that data is synced to the local workbook. I show you how to do that in this video: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html

@shosha579 4 жыл бұрын

You are amazing 😍

@ExcelForFreelancers 4 жыл бұрын

Thank you so much.

@justiceakoi4083 6 жыл бұрын

This tutorial is good. Nevertheless two things have been left out. First, Admin to monitor logins and second restrict users based on number of times they have to login (with Date and time). If there could be an update to this video, it will be the best on youtube ratings on Excel VBA..

@ExcelForFreelancers 6 жыл бұрын

Hi thanks very much for your comments. There are probably 100 features i wanted to add, or could have added, however I had to limit the training a bit. Concerning the Login Dates & Times, I have this in both Change Long 1 & 2 videos here: Change Log 1: kzfaq.info/get/bejne/bLqeq7OnseDDZGg.html Change Log 2: kzfaq.info/get/bejne/nKthaLpol9zSdXk.html

@garyjohn8297 8 ай бұрын

Great idea, and very informative. I also made it dynamic using a table and name ranges so that it would not crater (such as if a row were added midway through the hidden A:B data). However the greater need here is that it is totally possible for someone to accidently erase the Admin data, either by a delete key, or absent mindedly clicking that sheet so that nobody has edit access to it. This would make it impossible to edit the sheet, even if it were viewable. I did a few things to try to stop the errors, and then realized it could still occur beyond all efforts to avoid it. So to solve, I added two lines in the WBSecurity, so that if nobody is selected for rights to this sheet in the SecurityAdmin column, then it gives the right back to the Administrator's line, which I named "AdminAdmin". CkAdmin = Application.WorksheetFunction.CountIf(Range("SecurityAdmin"), "Ð") If CkAdmin = 0 Then .Range("AdminAdmin") = "Ð"

@ExcelForFreelancers 8 ай бұрын

Thank you for your feedback! It's always great to hear that the video was informative and helpful. I appreciate you sharing your insights and suggestions on making the process more foolproof. Keep up the great work!

@garyjohn8297 8 ай бұрын

FYI.. my moment of insight is accidental discovery. I was in the process of trying it out and had clicked the ‘all sheets’ of one line making all ‘view only’. Haha. Oops. The saving grace was I had used viewable, and that some code malfunction near the end allowed me to use the Immediate windows to change the information in the necessary cell for another run of the login.

@ExcelForFreelancers 8 ай бұрын

That's quite the accidental discovery! Sometimes the best ideas come from unexpected moments. Keep exploring and you never know what other insights you might stumble upon.

@riviera443 6 жыл бұрын

Thanks

@ExcelForFreelancers 6 жыл бұрын

For sure you are welcome.

@furdeansergiu1007 2 жыл бұрын

hi, thank you very much for the tutorial! it is great! One question though, how do you get the sheet names on row 4 ? Thank you very much !

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks, i use a formula for that, however you can simply type in the sheet name as that is a lot easier. If you would like to see the formula, feel free to download the workbook for free using the links in the description. I hope this helps and thanks so much.

@brianwollman3462 6 жыл бұрын

I really enjoyed the video and was able to follow along except for the the sheet names and it's formula could give a little more detail on that?

@ExcelForFreelancers 6 жыл бұрын

Hi thanks so much for the feedback. Make sure you also download the workbook from the links above. The formula to get the sheet names: =IFERROR(MID(CELL("filename",Sheet3!$A$1),FIND("]",CELL("filename",Sheet3!$A$1))+1,255),"") The 'filename' for any specific cell pulls the entire filename of the application including the path, workbook name and sheet name such as: C:\Users\Fred\Documents\User_Login_Security_Rights-2\[User_Login_Security_Rights.xlsm]Sheet3 But we only need the sheet name. So the formula uses "Find" to find the "]" and then returns all of the characters after this character, with a maximum of 255 characters, which is the actual sheet name I hope this helps.

@dreamninja4885 2 жыл бұрын

This video deserve more views and likes. Appreciate your share bruh.

@ExcelForFreelancers 2 жыл бұрын

Appreciate that and thanks so much.

@stevennye5075 4 жыл бұрын

excellent

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that Steven

@ziaajju Жыл бұрын

Hi Randy, Thanks for sharing much knowledgeable videos i really appreciate your hard work. I want to know does this file work in Microsoft 365 co-authoring, like on onedrive sharing any of my user can login with there id and it will store the data in data but each user ha different sheet in front of him and rest is very hidden sheet.

@ExcelForFreelancers Жыл бұрын

Hi and thanks so much. I have just uploaded a training on this. You can share and sync your macro enabled workbook with any desktop version of Excel using a shared folder such as Dropbox, OneDrive or Google Drive. I have a few videos on this, the latest is here To share and sync your macro-enabled Excel workbook, please watch this training: kzfaq.info/get/bejne/nMVhe9aDnpmUZX0.html

@khacchinhnguyen7859 2 жыл бұрын

Dear Randy Thank you so so much for great tutorial! Is is possible if when open file, I want to show not only sheet "Start" but also some another sheet?

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks for your comment. You can show any sheet on start when you either activate that sheet on Workbook Close event or when you activate the sheet on the Workbook Open event. 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

@matthewallgor5200 4 ай бұрын

This is a great video. Could you tell me how to do the double click and select the entire column instead of the row so that all users could see a certain page, much like what you have in your first column, just working the other way? For example, if you double click G5 it will change from G5 to G26, or H5 will change H5 to H26, so on and so forth.

@ExcelForFreelancers 4 ай бұрын

Hi and thanks you can use the Before Double Click event on any worksheet, then, within that event you can use something like Range(Cells(5,Target.Column),Cells(26,Target.Column)).Select Something like that will work. I hope this helps and thanks so much.

@stevennye5075 4 жыл бұрын

useful!

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that. Coming this week I will be adding training to teach you how users can reset their own password. It will be released on Nov. 5th :)

@umartwheelz7957 2 жыл бұрын

Hi Randy, thank you so much for your wonderful presentation. This is what I was looking for all my entire life. you are such a good teacher. I have been using excel but didn't know that Visual basic existed. Therefore I decided to follow your tutorial step by step, but my challenge is that I have done all the coding the way you did and successfully run most codes in the security work book but when I run it, I get a message box saying "Run time error '424' Object required", and when I click on "debug", it highlights a line in the code that says " If.cell(userrow.sheetcol.value = "D" Then". What can I do? I am on the last stages of completing the admin sheet

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks so much. I am glad you enjoyed the training. When you have that type of bug, that means your language pack does not recognize that character, so instead of that character with the quotes, you can use the character equivalent such as chr(208) instead of "D" You can find these numbers when you click Insert > Symbols, then use the Webdings Font and look for the character # in the lower right I hope this helps and thanks so much.

@sharfinahmed5584 2 жыл бұрын

Nice video

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that.

@mra893 7 ай бұрын

Nice

@ExcelForFreelancers 7 ай бұрын

Thank you so very much, I really appreciate that

@davidwentireland Жыл бұрын

Good video. Unless I am doing something wrong, unfortunately I have found that caution is required if you intend to use the finished sheet on a shared drive (like One Drive). If I, as administrator, have the sheet open and someone else logs on they will see all the available tabs - they might not be able to open them but one of the points of this approach was that they wouldn't even know the tabs are there. In fact, if person A is logged on and person B opens the sheet then Person B will see Person A's tabs.

@ExcelForFreelancers Жыл бұрын

Hi Dave, thansk so much for your comment. To solve this issue you can use OneDrive to share and sync the data only and not the entire workbook. Each user would have their own, unique workbook, and only the data, one cell at a time, is shared and synced. I show you how to do this in this video: Ikzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html I hope this helps and thanks so much.

@tazz1691 2 жыл бұрын

Thank you so much for the amazing video! Im facing some issues while the code for unprotect “shows script out of range” Any help would be highly apprised.

@ExcelForFreelancers 2 жыл бұрын

Hi Udit, Thanks for your comment. 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 40,000 Members who would love to help you with this. Thanks so much.

@rajakumarasamy4896 Жыл бұрын

Hi Randy, Thank you very much for this great video. I have a question. How to make the form appear when user opens the workbook through a web link (through sharePoint). Thanks

@ExcelForFreelancers Жыл бұрын

Hi and thanks so much. Inside the VBA Editor, check the Workbook module which has a Workbook_Open event, you can display a userform on that workbook open event. 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

@jakejames9686 3 жыл бұрын

Good afternoon Randy this is a fantastic video thank you. I have a question though. Is there a way that we can receive the same desired effect using the windows login automatically to log in. The above example works perfectly but my sheet has several users simultaneously working on it.

@ExcelForFreelancers 3 жыл бұрын

Hi Jake thanks so much for your comment. Yes you can have multiple users share and sync your macro-enabled workbook. This training will show you how: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html

@sritharank9366 Жыл бұрын

Great

@ExcelForFreelancers Жыл бұрын

Thank you so very much, I really appreciate that

@petekhauv2476 2 жыл бұрын

Great tutorial, thank you! How do I share a macro workbook in OneDrive that won't disable the macro?

@ExcelForFreelancers 2 жыл бұрын

HI and thanks so much Pete. I created a specific training on how to share and sync your macro-enabled workbook here: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html I hope this helps and thanks so much.