+ Reply to Thread
Results 1 to 2 of 2

Protecting workbook with multiple passwords

  1. #1
    Registered User
    Join Date
    11-17-2019
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    1

    Protecting workbook with multiple passwords

    Hi

    In my excel workbook, I have 3 worksheets.
    1. Sheet 1 is a database of companies
    2. Sheet 2 is a search query sheet (linked to sheet 1) for searches

    I have protected sheet 2, so the users can only key in the search query without changing formulas. And I have hidden the sheet 1 and then protected the workbook. So the user can only see sheet 1 and search for a company.

    Now I have a requirement of adding another sheet 3. It will pull specific data from sheet 1. I want to keep this sheet hidden as well from all users except 1-2. How can I do that with protected workbook. In summary, the access level is as below:
    Sheet 1 : Only me
    Sheet 2: All users (only access to search query, no editing allowed)
    Sheet 3: Only me and one other

    How can I protect my worksheets and workbook with these constraints?

    Thanks in advance.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Protecting workbook with multiple passwords

    Hi, welcome to the forum.
    I would add an Admin sheet where you place the list of users (usernames) and give each a ranking level, 1,2 3 etc.
    Depending of which level the get to see / use / access what they have the right to.
    A workbook and worksheets can each only have one password.
    So X passwords for X number of Worksheets (unworkable for maintenance) and only ONE workbook password, only options are allow to open read only or with password for editing
    ---
    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

+ 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. [SOLVED] Save a Workbook with Multiple Passwords
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-20-2015, 04:12 AM
  2. Multiple Workbook Passwords
    By DD1 in forum Excel General
    Replies: 6
    Last Post: 02-08-2015, 02:10 AM
  3. protecting document with multiple passwords
    By angel2903 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 05:43 AM
  4. Protecting Sheets with Multiple Passwords
    By sridhar_shri03 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2014, 11:12 PM
  5. Protecting information using multiple passwords in excel
    By chrsf249 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2013, 07:19 PM
  6. Please help Password protecting different sheets with different passwords
    By Joshua28 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2012, 11:01 AM
  7. Multiple passwords in Workbook/sheets
    By steve-feldman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-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