Maly

I'm not sure what you want but normally the cells to be
operated on are first unlocked on the Format Menu before
the sheet is protected.

If you need to unprotect the sheet during a macro you can
use a toggle in the code.

Protect = not proctect

Record the Protecting and Unprotecting the macro then
revise the code

regards
Peter Atherton

-----Original Message-----

does anyone know how to protect (unprotected) cells with
macros while
the sheet itself is protected? i'm running into run-time
errors
(Unable to set the Locked propertyof the Range
class '1004').

thanks!

maly_pajak


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.