I have a master file that I run a macro from. It opens all the files in a folder, do some updates, then save and close.
Right now the last tab the files is on when it's saved is on one sheet but I want it to be on another (summary) sheet.
I don't want to do the straightforward Sheets("Summary").Select in case people decide to rename the sheet. (I can tell them not to rename it but people tend not to follow directions that well.)
I don't want to "Protect Workbook" to prevent a rename as others might want to add other worksheets to do other work.
I can't use the sheet CodeName since I'm running the macro from the master file and the sheet is in another file.
Any other potential solutions?