How to create Multi-user Login Module in Excel VBA || How to Protect worksheet from other user

preview_player
Показать описание
#nsutradhar #excelvba
Today in this tutorial we would learn how to create a login module in Excel so that we can control the multiple users. How to Protect worksheet from other user or Keep confidential the excel file from clients

First of all we need to think how to develop this module step by step.

Step 1. create and design the user forms

Step 2. transfer the data from userform to worksheet

Step 3. Match the worksheet data by TextBox

If condition satisfied then you will be allowed to access the application. Here you can control the multiple users to access the application. Only admin can access all features.

UserID: Admin
Password: 123

If any one want to use this login module, you can drag and drop the userform into your application.
Write the vba codes for workbook open

If you like this video then comment please and subscribe my channel if didn't

Those who don't understand bengali then visit my blog. I will discuss the same in my blog

For download and vba code see the below link

Рекомендации по теме
Комментарии
Автор

Thank you for your video I Like your Videos keep it up Thanks

carcaremadison
Автор

very good, I'm Brazilian here, nice to meet your job.

braboss
Автор

if we make sheets how to make specific sheets according to its role
kindly make full video with role select and sheet access
thanks

animatedmovies
Автор

ভাইয়া,
আমি Data Entry করার জন্য একটি Sheet নিলাম, সেখানে যে যে User যে Data Entry করবে তাদের নাম সেই Data এর পাশে Automatic Entry হয়ে যাবে। ভাই কিভাবে করব যদি বলতেন অনেক উপকৃত হতাম।

dhrubotara
Автор

i have a question what is view form button used for since i didnt understand
how to restrict users from accessing specific sheets
kindly explain these two things
thanks

animatedmovies
Автор

Dear Bro, thanks for your video, but i made login page everything i follow step by step as you said it completed once i exit again i am going login asking user id and passoword i put same Admin & 123 but not accepting. why? how can i open this file. thanks

syedkhadeer
Автор

Please can some one send me the excel file itself. i want to look at the code

Realpaulandrew
Автор

Amazing vedeo sir but one question which user data save in data entry sheet user name date and time in column

ravikhede_official
Автор

ভাইয়া আমি ইউজারের জন্য একাধিক পেজকে হাইড করতে চাই। একটু বলবেন কিভাবে? উপকৃত হব

mahbooburrahman
Автор

আপনার নাম্বার টা দিবেন আমি একটা softwer make korte chai.

EmamMusafir.Official
join shbcf.ru