+ Reply to Thread
Results 1 to 5 of 5

Protection/Editing Multiple Files

  1. 08-22-2018, 01:20 PM #1
    stadesam000
    stadesam000 is offline
    Registered User
    Join Date
    08-22-2018
    Location
    Beloit, Wisconsin USA
    MS-Off Ver
    Excel
    Posts
    3

    Protection/Editing Multiple Files

    I have a lot of excel files that need to be changed in the same way, as in the same few cells for each file. The problem is they all have protection. I have scoured the internet for an answer and found some sites and videos explaining the multiple workbook editing and had little success using the macros that were provided, but I have not found anything for protecting/unprotecting multiple workbooks. I am rather inexperienced at the more advanced features of Excel, so any help would be greatly appreciated!

    Thanks!
    Reply With QuoteRegister To Reply
  2. 08-23-2018, 01:58 AM #2
    FDibbins
    FDibbins is offline
    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,938

    Re: Protection/Editing Multiple Files

    Hi, welcome to the forum

    Do YOU actually have the passwords 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
    Reply With QuoteRegister To Reply
  3. 08-23-2018, 09:16 AM #3
    stadesam000
    stadesam000 is offline
    Registered User
    Join Date
    08-22-2018
    Location
    Beloit, Wisconsin USA
    MS-Off Ver
    Excel
    Posts
    3

    Re: Protection/Editing Multiple Files

    Yes, I know the password. It is the same for all the workbooks.
    Reply With QuoteRegister To Reply
  4. 08-23-2018, 11:05 AM #4
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Protection/Editing Multiple Files

    The answer to this really depends on what kind of password/protection you mean. If you mean password protected file (File | Save As | Tools | General -> password to open/modify) then there is an argument when using workbook.open to supply the password.

    If you mean Workbook protection (Review | Protect Workbook) then this is a property of the Workbook object. Similar, if you mean Worksheet protection there is a property for each worksheet to protect/unprotect them.

    Depending on what kind of protection you mean depends on the right code/object/property/arguments to use.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me
    Reply With QuoteRegister To Reply
  5. 08-23-2018, 11:30 AM #5
    stadesam000
    stadesam000 is offline
    Registered User
    Join Date
    08-22-2018
    Location
    Beloit, Wisconsin USA
    MS-Off Ver
    Excel
    Posts
    3

    Re: Protection/Editing Multiple Files

    Ok, I got it. Thanks for all your help!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open CSV UTF-8 files (no acces to editing BOM)
    By garbanzhell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2017, 04:26 PM
  2. Editing multiple workbooks within multiple files at the same time
    By boyesmar in forum Excel General
    Replies: 9
    Last Post: 01-13-2014, 02:48 PM
  3. Password Protection & Email Multiple files
    By Ashali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2013, 02:50 AM
  4. Editing multiple files on Excel 2010.
    By Shahbaz Aziz in forum Excel General
    Replies: 16
    Last Post: 11-08-2012, 03:59 AM
  5. Protection and user editing
    By country101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2012, 01:21 PM
  6. Object Editing under protection
    By TheRetroChief in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-29-2008, 12:00 PM
  7. Editing Shortcut files
    By Fred in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2006, 08:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1