Test Excel.xlsm

Need Help. Macro to copy template based on the value in D.

If its A copy worksheet A and rename the document as per document no.
If its B copy worksheet B and rename the document as per document no.

Template to be created on doublclicking A, B in Column D.

Password in Register is "a"

Thanks in Advance

Bernard