Hello: Can anyone tell me a way to limit access to certain worksheets through the use of "passwords"?
Hello: Can anyone tell me a way to limit access to certain worksheets through the use of "passwords"?
Good evening tvwhome
Native Excel doesn't have the functionality to handle something like this, however I have a workbook template available that offers something like this. Each user has a username and password which must be entered when the workbook is opened. Once successfully entered the user can only see the tabs that you, as administrator have allowed them to. they can access these tabs on a read-only, or a read-write basis as decided by the administrator. The administrator of course has full access to all tabs in the workbook.
If you would like a copy of this file, then send me a PM with your e-mail address.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks