I have a macro that does things to xls files that are found in a long list of hyperlinks. Some of these hyperlinks cannot be opened because they are protected. Is there a way to unprotect and reprotect any protected files?
This is the relevant part of the code:
CodeNames = Range("Z2:Z" &...