Excel - Password to Open Specific Sheets
Вставка
- Опубліковано 16 лип 2024
- Learn how to use easily inserted macros to control access to worksheets. This is different from protecting changes to cells using a password; this prevents access to unauthorized sheets while granting access to authorized sheets.
(The passwords for the VBA Editor and Worksheet Protection are "password")
File Download Link:
www.bcti.com//wp-content/YT_D...
Link to video demonstrating worksheet cell access by username:
• Excel - Allow Edit Ranges
00:48 Access Sheet - Password Demonstration
01:10 Mission Objectives
02:06 Password to Unhide a Sheet
04:34 Macro to Hide Sheet
05:01 Protecting the Workbook
08:30 Assigning Macros to Launch Buttons
09:19 Plugging the Sheet Access Loopholes
11:46 Locking the Visual Basic Editor - Наука та технологія
Wonderful and effective way/solution to protect a workbook and its sheets.
Keep up the good work. 💥👋💯
Your skills are top and watching your videos is a real pleasure (nice voice too).
Such nice words. Thank you.
Excellent! Simple explanations and easy to follow them. Thank you for your time and effort.
Thanks for taking the time to watch and comment. 👍🏻👍🏻👍🏻
Amazing content yet again! You simply never disappoint. The pace of the tutorial was spot on. You took into consideration all important aspects. From the very beginning to the end. This is what differentiates this channel from other creators. Every video is a new project. Thank You for effort and time You invest in your videos! Can't wait for more.
We really appreciate your very kind words. That is high praise considering the vast amount of amazing content available from many very talented and brilliant content providers. Thank you so much for taking the time to watch and comment.
Very nice! It took me a while to realize that the reason the reason the "a_WB_Password" module wasn't listed in the Macros list is because it only has the "Const WB_Password" and has no other code.
Yeah, it's just there to make updating the "global" password easier.
Awesome video! Was looking for a way to do this recently and will come in very handy, thanks!
Glad we could be of service. Thanks for watching.
I have a question. I created my own spreadsheet using all of this. However, the one issue I am coming across is this... If anyone wanted to insert a pivot table from data model on the ToC sheet it opens up all the queries that are available in the sheet. Is there a way make it where no one can see or access the queries or connections?
You can prevent users from accessing the queries and reading the steps and/or "M" code by protecting the workbook for "structure". There are some considerations when doing this. Check out this great article explaining all the nuances of this technique.
excelguru.ca/protect-power-queries/
Thanks for watching!!!
Any plans to do a video on hacking my own forgotten passwords? I know, I know, I should set passwords that I'm gonna remember, but I have some rather old worksheets and I stand a snowball's chance of remembering those passwords. Please advise.
Is the entire file password protected for opening, or are certain sheets password protected for editing?
Does protecting the editor encrypt the VBA code, or is that already done by protecting the workbook?
The VBA code isn't encrypted, per se; but the file is by nature of the binary encoding. You may want to utilize passwords to open the workbook or enable "first pass" editing. It all depends on how hard-core you want to play.