|First, it is customary (and polite) to ask for help as opposed to just telling us what you want and what the solution has to be.|
Second, if you (as a user) can't use a VLOOKUP in workbook 2 due to its protection status, then a macro can't write data into the workbook either. If a macro could override protection so easily, then workbook/worksheet protection wouldn't be worth anything.
Yes, a macro can unprotect a workbook, even it if has a password, but that password has to written into the code.
If the workbook isn't password protected, then your statement "I cannot use vlookup formula on destination workbook2 it is protected" doesn't make sense.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.