chandelirious
Board Regular
- Joined
- Sep 9, 2004
- Messages
- 84
Hi, I wonder if you can help me at all.
I currently work on a large spreadsheet that is regularly used and worked on simultaneously by many people at once.
The majority of those working with it are not the most technologically minded people. As such, the worksheet is locked down quite heavily so that only certain areas can be edited by them.
However, when I'm in it - and it's a lot, and for long periods at a time - I need to unprotect the worksheet. During that time, others are working on it, and they frequently accidentally do things. I'm talking hiding columns, removing formulas, etc. They claim that they haven't done it, because they don't have access to the unprotected sheet. So I get the blame.
Ideally, I'd love to be able to say to them something along the lines of "You can't access the spreadsheet between 2.00 and 3.00pm every day," but that just won't work. Also, whereas I'm an office 9-5 worker, some of these are not, and will be accessing it out of office, so it's not even as if I can stay behind once a week to catch up.
So. With all that in mind. Is there any way that I can unprotect a worksheet just for myself? So that when the others are working on it, it is still protected for them, but not me?
Thank you so much in advance for any help you can offer!
I currently work on a large spreadsheet that is regularly used and worked on simultaneously by many people at once.
The majority of those working with it are not the most technologically minded people. As such, the worksheet is locked down quite heavily so that only certain areas can be edited by them.
However, when I'm in it - and it's a lot, and for long periods at a time - I need to unprotect the worksheet. During that time, others are working on it, and they frequently accidentally do things. I'm talking hiding columns, removing formulas, etc. They claim that they haven't done it, because they don't have access to the unprotected sheet. So I get the blame.
Ideally, I'd love to be able to say to them something along the lines of "You can't access the spreadsheet between 2.00 and 3.00pm every day," but that just won't work. Also, whereas I'm an office 9-5 worker, some of these are not, and will be accessing it out of office, so it's not even as if I can stay behind once a week to catch up.
So. With all that in mind. Is there any way that I can unprotect a worksheet just for myself? So that when the others are working on it, it is still protected for them, but not me?
Thank you so much in advance for any help you can offer!