Windows/User Authentication for Excel Workbook
Results 1 to 2 of 2

Thread: Windows/User Authentication for Excel Workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2016
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Windows/User Authentication for Excel Workbook

    Hey Guys,

    I have some 200 excel workbooks with password protected.
    Whenever i/my team wanna open this workbook need to be given the password, Is it possible to give some windows/User authentication for those specific excel sheet to bypass the password protection ?


    Dinesh S

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,818
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Windows/User Authentication for Excel Workbook

    you might encode all the books with specific user ENVIRON strings that you have worked out > https://www.techonthenet.com/excel/formulas/environ.php plus other references on the web
    • Yes I know there are better ways to do it. I just wish I knew them. - 97, 2003, 2007, 2010, 2013, 2016 & 2019
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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