$25 USD: VBA to protect muliple worksheets in other files in the same folder

  • I have multiple workbooks (20+) located in a same file path folder that I would like add sheet protection to. Each workbook has only 1 sheet (sheet1) in it. Is there a way for a macro to run on each of the files in this folder and add worksheet protection to them rather that doing it manually? I would like the password for the sheet protection = md


    I only need "Select Locked Cells" and "Select Unlocked Cells" checked for the properties.


    Is this something that is doable?


    Thanks!

  • Re: $25 USD: VBA to protect muliple worksheets in other files in the same folder


    Hello


    This is possible. I will write the code.
    Can you confirm payment of 10% to Ozgrid please?


    Thanks.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: $25 USD: VBA to protect muliple worksheets in other files in the same folder


    Thanks, I will complete the code for you.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: $25 USD: VBA to protect muliple worksheets in other files in the same folder


    Hi


    Attached is the coding. Can you please test it while changing the path (do not forget to add with a \ character).


    Thanks for your feedback. I will send a private message with my PayPal ID.


    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: $25 USD: VBA to protect muliple worksheets in other files in the same folder


    Thanks, payment received ! :-)

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --