Hi,

I have the workbook called "Sales". which has 3 sheets
Sell,
Buy
Rent

Now I want to move only sheet Sell ( only values and formats not formulas) to another workbook which is located in C:\Documents and Settings\DC87\Desktop\Sales\File1.xls
however the file File1.xls is password protected and the password is "Test123".

Please help me to do this in a macro

Regards
Arvind