Hi, all
I have a workbook with say 7 worksheets.
I want to protect each worksheet to specific LDAP users.
ie, User Jane Doe can see worksheet #1(no permissions set) and her worksheet #3. 2, 4-7 she will be denied access.
Is there a way to protect a sheet to a user-not just a range?
You could hide all the sheets, except one which would be just an empty sheet. Then use VBA to get the user to log in & unhide the relevant sheets(s). Do a search of the Forum for Passwordfoem posted by me
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Hi roy,
Great ideam but, I am very inexpirenced with excel. The only way this could be function is if it integrated with their Windows LDAP login. They wouldnt go for another password to remember.
Would setting edit range permissions with using just a larger range then the user should ever reach be a smart idea? ie edit range permissions for range 2:1000?
It works for what I need. But, are there any problems I dont forsee?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks