Hi:

I am developing a macro which will copy data from one workbook to another. Both workbooks
are password protected.

I need to have a macro that will un protect the worksheet and then another that will re
protect it with the same password. Its OK if the system knows the password.

"ActiveSheet.Unprotect" works fine IF there is no password, but if there is one it asks
for it, and that's what I don't want. The same is true of

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True


adding Password="xxx" does not work, and somehow the help file doesn't help either.

Can someone give me the magic words that will make this function.

Thanks

John Baker