You're a lifesaver works perfectl
----- Chip Pearson wrote: ----

Paul

Try something lik

Worksheets("Sheet1").Unprotect password:="whatever
' your code her
Worksheets("Sheet1").Protect password:="whatever


--
Cordially
Chip Pearso
Microsoft MVP - Exce
Pearson Software Consulting, LL
www.cpearson.co


"paul d" wrote in messag
..
Is it possible to unprotect a sheet using a macro the
manipulate data in the sheet and then repassword protect in th
same macr