+ Reply to Thread
Results 1 to 2 of 2

Shared Worksheet with multiple passwords

  1. #1
    Registered User
    Join Date
    06-21-2017
    Location
    New York NY
    MS-Off Ver
    2013
    Posts
    6

    Post Shared Worksheet with multiple passwords

    Hello Excel Gurus!

    I am looking to create a spreadsheet that is to be updated between multiple users, but want to lock certain columns for specific users. Is this possible?
    For example:
    column A-F (password 1)
    column G-J (password 2)
    column K-N (password 3)

    I understand I can make certain cells editable for one password but how to make multiple passwords for the same sheet?

    Has anyone done this before?

  2. #2
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92

    Re: Shared Worksheet with multiple passwords

    I believe you can, at least according to this link here.

    https://support.microsoft.com/en-us/...rate-ranges-in

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple passwords for different users. Access restricted to certain worksheet
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-28-2016, 02:19 AM
  2. Replies: 2
    Last Post: 03-25-2015, 09:04 AM
  3. protect worksheet with multiple passwords
    By andyc209 in forum Excel General
    Replies: 2
    Last Post: 02-18-2014, 12:06 AM
  4. Different Worksheet Passwords
    By AndyK737 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2013, 03:18 PM
  5. access to worksheet protected by different passwords
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2011, 08:01 PM
  6. Replies: 4
    Last Post: 08-16-2011, 09:32 PM
  7. Limiting worksheet access through passwords
    By tvwhome in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-22-2010, 03:52 PM

Tags for this Thread

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