Steven Revell wrote:

I'm not sure what you mean by respect.

Cells will only be locked if the worksheet is locked:
activesheet.protect "mypass"

if a worksheet is not locked then cells will not be locked even if their properties say they are.

Let me explain what I'm trying to do more clearly: I want to toggle
between two worksheet states...

1. all cells locked from use (total protection)
2. some cells locked from use (partial protection)

I'm thinking I'll have to somehow hardcode the locked cells references,
but I don't want to have to do that! :)