![]() ![]() ![]() ![]() The easy option would be to leave them unprotected but there are other people's private details hidden within the document that I do not trust users not to look at and that are necessary to be in the workbook as they contribute to various formulas etc.Īll of the files sit within the same folder on the intranet and share the same password for all protection, so I was hoping there was a way of writing code to look at all files within the folder and then open them with the password - then I'd use Kutools merge function - and then code to lock all the files the same way that they were before. I'm currently using Kutools combine function but come across a issues as my worksheets and workbook structure are protected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |