Malheureusement, un clic hors de la fenêtre et l'accès à la feuille est autorisé. Ca ne bloque en rien l'accès. Sympa pour l'exercice. Unfortunately, one click outside the window and access to the sheet is allowed. It does not block access in any way. Thanks for the code which is very nice.
One can open it from the mobile app.(The prompt box won't appear in mobile app) There is one more way by which we can directly get the password. ie, when we try to open it from the browser we are geting time to click on the 'extension' before appearing the prompt box .Thus we can open the script editor and one can see the password there. Any way I appreciate your work
Thanks for the feedback, I'll rectify these problem and try to find solution for these issue and maybe I'll make an updated video for this. By the way thanks for your appreciation.
Thank you for this video, is was something I was looking for, the only problem is, I need the password to show before it show the sheets data, is this possible
Sir, ek Google sheet hai us me 4 salesman wise 4 sheet hai har salesman apne Naam Ki sheet me data daily update karke n dusre salesman ki sheet na dekh sake and all salesman sheet manager dekh ske Yeh manage google sheet me kese kare?
Sir its works amazingly but... Whenever we sign out this particuoar mail id and we are trying to paste this url agin with diff mail id then te password protection is not work the excel file can easily open without asking any password
yes. we need some method so that we can tackle it. i request the owner of this youtube channel to help in tackling this practical problem p.s. i highly appreciate this video which is rendered with so wonderful and simple explanation
Hello my file is shared through multiple user. Can I password it only on my Google account? And the rest can freely open it using their own google acc?
This code is works fine when the sheet access and password wasn't share with anyone. If we share this sheet and password, all the user whom we share the sheet will be able to change the code. For protecting the code from other users, we are working on it. Will share the video once that is done.
I can understand your feelings, and thanks for the concern. Since I don't know to speak Hindi, I was not able to make videos in Hindi but I'll try to add subtitles in Hindi.
#FailureToProtectWithPassword 🔐🔓 If you click another part of the screen, the "Enter Password" pop-up will disappear, and you can edit it without a password. However, you will receive notifications on your email immediately, which is good. But It would be a good option to protect your G Sheets with a password, If it's work properly. Please provide us with alternative methods, sir. Thank you! 😊 How to enable Password Protection in the Add-ons option on Google Sheets?
It's a condition which will check for the correct password and clicking on ok button. providing correct password and clicking close (closing pop-up window) or providing wrong password will prompt for message. only clicking ok and providing correct password will allow you in .
Thanks for your valuable feedback. Kindly follow all the steps without skipping any steps shown in the video. If its still not working kindly DM me in Instagram @google_sheet
Thanking sir for providing code
Thanks for your valuable feedback. Kindly Subscribe my channel and keep supporting for other videos.
Thank you sir for this very informative and easy to follow content. Keep uploading this kind of video. Thank you!
Thank you, I will
Malheureusement, un clic hors de la fenêtre et l'accès à la feuille est autorisé. Ca ne bloque en rien l'accès. Sympa pour l'exercice. Unfortunately, one click outside the window and access to the sheet is allowed. It does not block access in any way. Thanks for the code which is very nice.
Great-. but is there a way to hide the data from visibility preior opening. I notice the data can be easily viewable. Many Thanks
Thank You so much
Big Thanks sir !! 👍👍🎉🎉
Welcome Sir👍
Nice idea, but a bit slow.
Hi! Can I kindly know if it's possible to set a specific password for each tab in a Google Sheet?
One can open it from the mobile app.(The prompt box won't appear in mobile app)
There is one more way by which we can directly get the password. ie, when we try to open it from the browser we are geting time to click on the 'extension' before appearing the prompt box .Thus we can open the script editor and one can see the password there.
Any way I appreciate your work
Thanks for the feedback, I'll rectify these problem and try to find solution for these issue and maybe I'll make an updated video for this. By the way thanks for your appreciation.
duplication of sheet is also possible
Thank you for this video, is was something I was looking for, the only problem is, I need the password to show before it show the sheets data, is this possible
Very helpful
Glad it helped
Hi
Thanks for your code sir,
how to create different pwd for different users ,who having rights to open and write in the Sheet
Thanks
Sir, ek Google sheet hai us me 4 salesman wise 4 sheet hai har salesman apne Naam Ki sheet me data daily update karke n dusre salesman ki sheet na dekh sake and all salesman sheet manager dekh ske Yeh manage google sheet me kese kare?
Sir its works amazingly but... Whenever we sign out this particuoar mail id and we are trying to paste this url agin with diff mail id then te password protection is not work the excel file can easily open without asking any password
yes. we need some method so that we can tackle it. i request the owner of this youtube channel to help in tackling this practical problem
p.s. i highly appreciate this video which is rendered with so wonderful and simple explanation
thank u brother
Thank you Iman Budiman for your valuable support. Kindly Subscribe my channel and keep supporting my other videos brother.
can we protect certain cells only rather whole sheet?
Hello my file is shared through multiple user. Can I password it only on my Google account? And the rest can freely open it using their own google acc?
Can you please share me the code to copy paste. I could not find it in the description
bit.ly/3hopJnr
how about to protect with password certain ranges and the trigger is onedit?
But this is working only for the Google account on which you are working, for rest of others its not asking any password.
Please suggest something.
Why sheet unlock when dubble click it. How i solve. I use your code step by step
AT THE TIME ENTER PASSWORD CLICK ESC BUTTON FAILED PASSWORD THEN OPENED SHEET
You can press 'X" to close the dialog and don't need to enter the password
But can the app script be locked so that people don't go in and delete the code? thank you
But the user is able to change the code to whom the spreadsheet link is shared. How do you protect this code from such users..
This code is works fine when the sheet access and password wasn't share with anyone. If we share this sheet and password, all the user whom we share the sheet will be able to change the code. For protecting the code from other users, we are working on it. Will share the video once that is done.
it is not working if you enter the spreadsheet using mobile devices, people can still edit it sir
Bhai hindi me tutorial bna le .. english vla accent to h ni ... so india me kafi odience h to learn these things
I can understand your feelings, and thanks for the concern. Since I don't know to speak Hindi, I was not able to make videos in Hindi but I'll try to add subtitles in Hindi.
the script doesn't work on android phone, any solution for that?
#FailureToProtectWithPassword 🔐🔓
If you click another part of the screen, the "Enter Password" pop-up will disappear, and you can edit it without a password. However, you will receive notifications on your email immediately, which is good. But It would be a good option to protect your G Sheets with a password, If it's work properly.
Please provide us with alternative methods, sir. Thank you! 😊
How to enable Password Protection in the Add-ons option on Google Sheets?
How to set different PW for Sheet 1 & different PW for Sheet 2
this is what im also looking for @googlesheets
I create a script in my Google sheet but I see one error (row no. 5) so plz solve this error
can you provide me the code and error screenshot
It Did'nt Work For Me
What did u type on 11:42?
It's a condition which will check for the correct password and clicking on ok button.
providing correct password and clicking close (closing pop-up window) or providing wrong password will prompt for message. only clicking ok and providing correct password will allow you in .
@@google_sheethi
Not working
Thanks for your valuable feedback. Kindly follow all the steps without skipping any steps shown in the video. If its still not working kindly DM me in Instagram @google_sheet