Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default Protection - multiple ranges at different times

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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WS Protection: Different Levels of Protection on Different Ranges Carmi Excel Discussion (Misc queries) 4 August 31st 07 02:26 PM
Can I create Multiple passwords to edit multiple ranges? Conker10382 Excel Discussion (Misc queries) 8 December 31st 06 07:58 PM
protection / edit ranges Liz Excel Discussion (Misc queries) 2 August 25th 06 04:48 PM
How do i update multiple data ranges across multiple worksheets? mwah Excel Discussion (Misc queries) 0 July 6th 06 04:57 AM
Validation protection with named ranges Ben H Excel Worksheet Functions 1 March 17th 06 03:49 AM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"