+ Reply to Thread
Results 1 to 2 of 2

Protecting information using multiple passwords in excel

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    Protecting information using multiple passwords in excel

    Hello Everyone,

    New to this forum so please hang in there with me. I have a spreadsheet with information from multiple companies. I have created a drop down so they can view their own information. Is there a way when "company 1" picks their company name from the drop down they can only view their information and "not company 2"? I need to restrict viewing access for each individual company. Any help would be great.

    Thanks
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Protecting information using multiple passwords in excel

    Hi and welcome to the forum

    Im sure someone can put soem VBA together for you for this, but be aware that excel has notoriosly poor security - there are a kazillion ways around its security levels
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. 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
  2. Multiple passwords for different users
    By pooley343 in forum Excel General
    Replies: 2
    Last Post: 05-10-2011, 12:10 PM
  3. multiple passwords
    By vivi in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-08-2010, 11:10 AM
  4. Help protecting Multiple Excel 2003 WB with filtering enabled
    By yogib in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2006, 06:09 PM
  5. Help w/Protecting a Pivot Table through many unique passwords
    By NicoleHKeller in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2005, 09:05 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