Greetings,
I know how to protect sheets in a given workbook with a password but I would like to know if there is way to make it so that a person is required a password to even view a certain sheet in a workbook.
Any help would be greatly appreciated.
Not without VBA
HTH
Regards, Jeff
Is there a sample code that can be provided since I have very little VBA programming experience?
Right click on the sheet tab >> View Code >> paste code in sheet module
Now when the user selects the sheet tab they will be prompted for a password which must equal "temp"
Please Login or Register to view this content.
alright cool. thank you. is the code able to prevent viewing the sheet until a password is prompted because right now the code seems to allow the sheet to be viewed then followed by a prompt for a password
I don't have a good working sample in front of me here, but maybe I can get one later.
Just a little clarification on what you are trying to achieve though.
Once the user picks the sheet they want to view and they enter the correct password, what is to happen after they are done or better yet, when they close the file?
If a user leaves and goes to another sheet I would like the protected sheet to remain unlocked or viewable until they completely close the workbook in which case they would need to enter a password again when they open up the workbook and select the sheet again. Im not pressed for time so when ever you get around to it, I would greatly appreciate it.
Hi, Paragoomba,
maybe you can explain if we are talking about one worksheet that one person isnīt allowed to see or if we are talking about several sheets of which some sheets may only be seen by certified people? This would mean a hidden worksheet in the workbook with a lookup table who is going to see which sheets and a UserForm for both the name of the user and password as well as either a Listbox or ComboBox listing the sheets for that special user once the password suits the username entered.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There will be several sheets that will need to require a password in which anybody who has access to the password will be able to view. I cannot attach my workbook since the information is confidential.
Try this. I think this is what you are trying to accomplish.
password tab.xlsm
Hi, Paragoomba,
maybe like this.
For hiding the sheets in ThisWorkbook:
For bringing up the UserForm behind Sheet Master:Please Login or Register to view this content.
Behind the UserForm frmAccess:Please Login or Register to view this content.
Default button when leaving the TextBox is Cancel.Please Login or Register to view this content.
Ciao,
Holger
The trick I used to keep people from seeing ANY part of the sheet while the password prompt is onscreen is to send them to a blank part of the sheet while this is going on.
This should give you something to play with:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks guys. Youve been a great help.
JBeaucaire,
Are you able to make that code to where you don't have to re-enter the password every time you click on the sheet? Only when you close and re-open the file.
post deleted
Last edited by Paragoomba; 07-08-2013 at 09:29 AM.
Like so, just edit the password at the top:
Please Login or Register to view this content.
As for forcing macros to be enabled, that's a whole different topic. You can Google that question (Excel VBA force macros to be enabled) or start a new thread.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Excellent, thank you very much,
I figured out how to automatically enable macros as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks