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

thanks!

maly_paja

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

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/

.

Hello Maly,

You need to unprotect your sheet first.

Activesheet.Unprotect "PASSWORD"
'your code here
Activesheet.Protect "PASSWORD"

Replace "PASSWORD" with your password if there is any otherwise don't
include that word.

Regards,

Jon-jon

"maly_pajak" wrote in 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/