Hi im a new here. Can anyone teach me how to do the abovementioned subject using excel vba? Both workbooks are existing and... -has a protection under REVIEW (Protect Workbook) = to avoid add/delete/rename the sheet; -both sheet1 of the workbooks are also sheet protected. Many thanks in advance.