Hi, I want to give multiple people access to a workbook, but protect some of the internal sheets with passwords so that they can only be viewed if you have the password. How do I do this?
So far I have been able to password protect a worksheet but you can still see all of the data so its unsecure.
Thanks.
Excel is not a secure environment. If the data is there, it will be accessible to anyone with a little knowledge.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Like @TMS says Excel is not entirely secure but if all users are not out to crack it than you can protect but you also woould need to hide the worksheets you don't want the users to see.
Protection alone is not enough and it cannot be done with formula's you will have to program the code to do this, you will have to resort to VBA.
If your knowledge of VBA is zilch then don't start on it but first read up on tutorials before starting or you will at all times be dependent of others to code it for you.
If you search the forum you will find many posts with protecting and hiding worksheets and how to even allow one user to see worksheet A and another only B etc etc.
It's long way but if you want to do it good, start from the beginning and you'll get there
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thanks.
Understand its not entirely secure, and actually thats not a main concern. I have searched a lot for protecting sheets, but i can only see passwords where the sheet content can still be seen, and hideing them but i do not want to hide them from everyone. Some people still need to see and have access. Excel is powerful so id be surprised if there is not somethig simple for this (it seems a sensible common user case scenario). Hopefully avoid VBA unless its easy as i have no experience there.
Any help appreciated.
Paul
What you need to look into is the 'very hidden' option in the VBA editor. I expect that someone will be able to explain to you how to use this with a password to create the effect you want.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks im not sure either hiden or very hidden really achieves it. As it over complicates the right users gaining access to it (need to be as simple for them as possible).
Ideally the sheet tab will still be there, but if you click on the tab it asks for a password before opens it. Seems obvious and simple, not sure if its possible.
Or alternatives to acheive similar.
As Ali said, you can make the sheet very hidden. You could put a button on a visible sheet that says "Click here to see data (password required)" (or something to that effect), and then when they click it, display a user form that has an input box for a password. If password accepted, display the "very hidden" sheet.
Of course the issue is (as has already been said), Excel is not entirely secure so you can't entirely secure data from someone who knows Excel well.
Thanks for the extra explanation, it helps to see how very hidden could possibly be used.
Please could anyone share any instructions how to set up the button with a password to direct to the very hidden sheet?
Many thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks