Well, I'm at it again, trying to get this spreadsheet to do what I need it to do. So far, so good, thanks to all the help from everyone here.
Now, I need to protect ONLY certain parts of the sheet. All the places where I need to input figures should be available, but everything else needs to be protected against change, because sometimes when I'm in a hurry, I don't put the cursor in exactly the right spot, and if I don't notice it right away, I have a problem.
Here is what I want:
I have wrestled with the Review -> Protect Worksheet for a couple of days, and cannot get it right. And, oh, yeah, I'm using Microsoft Excel 2007Code:The date and time columns need to be protected against change, but the level columns open for entry. Date | Time |Level| Time |Level| Time |Level| Time |Level| Tue, Oct 01, 2013 | 7:37AM | 110 | 12:25PM | 100 | 5:46PM | 97 | 10:07PM | 113 | Wed, Oct 02, 2013 | 6:32AM | 108 | 1:23PM | 96 | 5:26PM | 96 | 12:04AM | 96 | Thu, Oct 03, 2013 | 8:12AM | 142 | 2:33PM | 101 | 10:28PM | 73 | 1:12AM | 107 | Fri, Oct 04, 2013 | 7:09AM | 87 | 12:33PM | 121 | 3:54PM | 97 | 11:31PM | 122 |
Thanks for your help.




Reply With Quote
Bookmarks