macro to copy rows and paste-special to another workbook
 

I need a macro that upon closing of the workbook will copy all the non-empty
rows of a specified worksheet, say "Sheet1" and paste only the values
(paste-special, and not formula or links) to a specified sheet of another
protected workbook. The destination workbook should be locked upon pasting
the new values. Password can be embedded in the macro. I need to make this
happen automatically without opening the destination workbook.

Thanks for your help!