Hello, I need some help. This is my first time posting here so apologies if I overlook something. I'm a VBA novice and I did search for a solution but haven't been able to find anything that works for me yet.
I'm trying to copy the first sheet from 40+ department workbooks into a new consolidated workbook. All of the file names start with "2020-Q2-" and all workbooks are protected with the same password. Only the workbook structure is protected, not the file itself, no password is needed to open the file. The name of the first sheet in each workbook differs and should remain the same when copied to the new consolidated workbook.
After copying the first sheet from each department workbook to a consolidated workbook, the departmental workbook doesn't have to be protected anymore but I do want to password protect each of the department files with the same password so that they can only be opened as "Read-Only" by users without the password going forward.
Any assistance is much appreciated!
I'm trying to copy the first sheet from 40+ department workbooks into a new consolidated workbook. All of the file names start with "2020-Q2-" and all workbooks are protected with the same password. Only the workbook structure is protected, not the file itself, no password is needed to open the file. The name of the first sheet in each workbook differs and should remain the same when copied to the new consolidated workbook.
After copying the first sheet from each department workbook to a consolidated workbook, the departmental workbook doesn't have to be protected anymore but I do want to password protect each of the department files with the same password so that they can only be opened as "Read-Only" by users without the password going forward.
Any assistance is much appreciated!