Protection - multiple ranges at different times

P

PurpleMilk

Hi,

I'm using Excel 2003 and have a process that requires certain cells in a
worksheet to be available at different stages. For example:

1) at the beginning of the year, I would like columns A thru M to be
available for entry (all these cells are "unlocked" on Format menu)
2) then 3 months later I would like to block off columns A thru D and leave
only E thru M open
3) then 3 more months later, I would like to additionaly block off columns E
thru H and only leave J thru M open, etc etc etc

I have assigned multiple protectiopn ranges and each has it's own unique
password.

All is fine and dandy for stage 1, however when I get to stage 2 and try to
lock down columns A thru D - somehow these columns are still available for
entry??? It's like nothing changed? Why?

I've tried multiple ways around this - but can't seem to get stages of
protection applied.


Any help would be GREATLY appreciated!!!!!

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top