+ Reply to Thread
Results 1 to 8 of 8

Bypassing password entry

  1. #1
    Registered User
    Join Date
    09-19-2018
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    2016
    Posts
    5

    Bypassing password entry

    Hi - I have a master spreadsheet that contains links to several other worksheets (some of which have passwords) and everytime I (or one of my managers) open the master workbook it asks for the password.

    Is there a code (or macro - though not sure what I am doing with a macro - be warned!!) that can stop having to input the passwords everytime the workbook is opened?

    Already asked this question here on the Mr Excel forum with the same title FYI.

    Thanks
    Iain
    Last edited by Iain McBride; 09-19-2018 at 09:52 AM. Reason: Been advised to by DominicB

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Bypassing password entry

    To unprotect all sheets when you open the Workbook, you can use this code.
    Please Login or Register  to view this content.
    Put this in ThisWorkbook section. (Alt + F11) -> ThisWorkbook
    Replace abc with your password
    Click the * Add Reputation below to say thanks.

  3. #3
    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

    Re: Bypassing password entry

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    09-19-2018
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    2016
    Posts
    5

    Re: Bypassing password entry

    Apologies - didn't realise - have updated the original post with notes as to other forum posts (cant post links!)

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Bypassing password entry

    I note there is a fundamental difference between your problem descriptions here and at Mr Excel (https://www.mrexcel.com/forum/excel-...ord-entry.html). Here you refer to "several other worksheets"; there you refer to "approximately 20 other workbooks". Any solution will depend on using code applicable to the situation you're actually dealing with.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  6. #6
    Registered User
    Join Date
    09-19-2018
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    2016
    Posts
    5

    Re: Bypassing password entry

    Fair answer Macropod - currently there are about 9 workbooks linked to the master spreadsheet but as our workers go back into schools I envisage there being about 20 linked workbooks in the upcoming month.

  7. #7
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Bypassing password entry

    Now also cross-posted at: http://www.vbaexpress.com/forum/show...e-needing-help!!
    Kindly read -and abide by - Excel Forum's rules on cross-posting, as previously requested.

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Bypassing password entry

    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 4
    Last Post: 12-05-2014, 10:44 AM
  2. Userform with Login and Password (with limited number of entry for password)
    By bhavsarankit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2014, 03:53 PM
  3. Replies: 2
    Last Post: 07-09-2012, 02:05 AM
  4. Getting macros to go around password entry
    By Cidona in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-03-2011, 02:40 PM
  5. ByPassing Passwords when pulling stats from external password-protected files
    By jameztown in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-27-2010, 02:36 PM
  6. No entry to a sheet without a password
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2008, 12:23 PM
  7. Bypassing Excel's FTP login/password dialog
    By tmant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2008, 03:48 AM

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