Couldn't you just password protect it after you did the paste?

Or do you mean you want to use the same password--and it's not available to you?



"halem2 <" wrote:

Hi:

I have a sheet that I copy and past with a macro. The original sheet
is protected with a password but when the macro copies and pastes into
another sheet, it is no longer protected.

Is there a way to pass a password to protect the new sheet???

thanks!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson