Close other workbook after Copy/Paste?

I have 2 workbooks. The user is working in workbook1, and clicks a button in a userform to open workbook2. After the user finds the correct data in workbook2, they click the cell, right mouse button "Copy", then manually Close workbook2, then right mouse button "Paste" the data in the userform textbox.

I want workbook2 to close automatically after the Paste command. Is this possible?

Can you show me the way?

I attached workbook1 (open_close.xls) and workbook2 (anvils.xls)

Thank you for helping me.

"RMB Paste"?

RMB = right mouse button, sorry.

I would like to close the second workbook after the copy/paste is completed by the user, so the user does not have to manually close the other workbook.

I am reluctant to touch Andy's lovely code. It seems one place it could be done is

Please Login or Register  to view this content.

... but that's really a hack.