+ Reply to Thread
Results 1 to 4 of 4

Help making a macro to unprotect 2+ workbooks that have the same password

  1. #1
    Registered User
    Join Date
    11-02-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Question Help making a macro to unprotect 2+ workbooks that have the same password

    Hi there,

    First time poster here, I am wondering if there is a way to mass-unprotect multiple workbooks at once. I basically have one directory, and all of the individual .xlsm files are in there. There are around 400 individual workbooks, some of which are protected, while others are not. Of the ones that are protected, all of them have the same password. Can someone help me figure out a way to unprotect all of them at once? I am still really new to VBA, so a breakdown of what's going on in the code comments would be really nice too.

    Thank you!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,069

    Re: Help making a macro to unprotect 2+ workbooks that have the same password

    Do you actually have the password for those files?
    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

  3. #3
    Registered User
    Join Date
    11-02-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Re: Help making a macro to unprotect 2+ workbooks that have the same password

    I do have the password for all of these files.

  4. #4
    Registered User
    Join Date
    11-02-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Re: Help making a macro to unprotect 2+ workbooks that have the same password

    I do have the password for these files, yes.

+ 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. Macro to Prompt for Password and Unprotect Sheet
    By slindfors in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2016, 02:18 PM
  2. [SOLVED] Error on password unprotect macro upon workbook open event
    By phpolicylady in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2015, 02:00 PM
  3. How to Prompt for Sheet Unprotect Password using a Macro
    By cvishu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-18-2014, 05:34 AM
  4. Add unprotect and protect password to Macro
    By Vicious00013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2014, 11:52 PM
  5. [SOLVED] Ran Macro that Password Protected Sheets, Now won't Unprotect
    By pjdumont in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 02:17 AM
  6. Record a macro which enters a password to unprotect a workbook
    By Zeon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 03:25 PM
  7. Macro to protect/unprotect with password
    By Cam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2005, 06: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