Right, I guess I am looking for a code that will open all the files I select one at a time, protect sheet 1 (Clients), close the file, then move to the next one.
I have a "Combine" macro that does something similar to this... it allows me to select multiple files, it opens them one at a time, copies and pastes data from them into a "Master" sheet and then closes them.
This is that code:
I guess I was hoping for a code that could do something similar for locking multiple files... It may not be possible, but I thought I would check with the experts.
Bookmarks