+ Reply to Thread
Results 1 to 2 of 2

Limiting worksheet access through passwords

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    31

    Limiting worksheet access through passwords

    Hello: Can anyone tell me a way to limit access to certain worksheets through the use of "passwords"?

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Limiting worksheet access through 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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1