MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macroing problem

Posted by Joe on November 06, 2001 7:55 AM

I am writing a macro that copies information from one worksheet and pastes it into another and I'm wondering if there is a macro command that will allow me to unprotect a worksheet, and then at the end of the macro protect it again.

Anyone have any ideas?

Thanks for any help!

Posted by Barrie Davidson on November 06, 2001 7:57 AM

Try these commands:

Sheets("Sheet1").Protect password:="Pass"
Sheets("Sheet1").Unprotect password:="Pass"

BarrieBarrie Davidson

Posted by Joe on November 06, 2001 10:38 AM

Thanks a million!

Thats what I needed!

Thanks again.