| Lock down your cells with protected ranges | Teresa C. | 8/7/12 3:59 PM | Hi everyone, When you're working with a lot of people in a spreadsheet, sometimes it's easy for someone to accidentally modify a cell they shouldn't be. Starting today, you can lock down individual cells with protected ranges. Check out our blog post |
| Re: Lock down your cells with protected ranges | Taylorr | 8/7/12 6:17 PM | Prior to the recent cell protection feature, every time a user would open a spreadsheet, a trigger would run this Google apps script code: function viewcount() { var cell = SpreadsheetApp.getActiveSpreadsheet().getRange('H1'); cell.setValue(cell.get |
| Re: Lock down your cells with protected ranges | KINgiS123 | 8/7/12 6:23 PM | Finally got this feature. Thx YOU :) |
| Re: Lock down your cells with protected ranges | Pinus | 8/8/12 2:42 AM | I I've tried and it work's great, but there's a catch. The people that are "locked down" get to see a "dotted hatch" on top of the cell's that they can't change. That hatch is disturbing and not compatible with long working hour's trying to read valu |
| Re: Lock down your cells with protected ranges | Stripe | 8/8/12 3:41 AM | Good feature addition! I've got a problem, though. I have a "visible to anyone with the link" spreadsheet. I protected a range and then edited that range, On clicking the "modify permissions" button, the popup reads "Anyone who has the link can edit" |
| Re: Lock down your cells with protected ranges | Brad 2012 | 8/8/12 8:36 AM | Great, long awaited feature. I notice two bugs: 1) if you (as owner) protect a named range, and give yourself "view only" access (most useful to prevent yourself from accidentally trashing important cells), it is impossible thereafter to remove the |
| Re: Lock down your cells with protected ranges | msapdx | 8/8/12 9:09 AM | I love the option of locking down cells. But, the process to change settings for other users to "view only" is tedious. It would be nice to be able to expand the small pop-up window that lists users, and then, rather than using drop down menus to ch |
| Re: Lock down your cells with protected ranges | Taylorr | 8/8/12 10:04 AM | I also agree with the others that mentioned it; the crosshatch over view only cells is quite distracting. It makes it seem as if they're not allowed to be there, when they're only meant to not be able to edit them. They should look like any other cel |
| Re: Lock down your cells with protected ranges | UFO64 | 8/8/12 12:44 PM | Awesome! This has LONG been needed. A few issues though. - I cannot guard cells from myself. It is nice to lock down a cell to prevent accidental overwrites. - Protected ranges show up on all sheets in a workbook. It would be nice to be able to fi |
| Re: Lock down your cells with protected ranges | APL+ | 8/8/12 6:36 PM | Similar to this issue: 1. Create a named protected range (say Sheet1!B5:B10)2. Delete the column that contains that protected range3. The named protected range persists, but it always seems to be converted to Sheet1!A1. Also, the protection settings |
| Re: Lock down your cells with protected ranges | roselan | 8/9/12 6:42 AM | you will get of friends with this feature. I would love to be able to "reverse" it. What I mean is to have an option to lock the full document or tab!, and unlock a range of cells. In most spreadsheet "apps", you have pages and pages of data and form |
| Re: Lock down your cells with protected ranges | UFO64 | 8/9/12 8:54 AM | @RoselanIf you just want to lock a sheet, you can already do that from the tabs. Open up the menu by clicking on the little arrow on the tab you want to lock, and select "Protect Sheet...". Everything else you have listed you can't do (yet) apparentl |
| Re: Lock down your cells with protected ranges | QuadT | 8/9/12 9:17 AM | I'm still waiting to see the new feature. I used it heavily in Excel and have been handicapped without it in GD. So I'm wondering why my docs haven't updated yet. I don't see the "Name and Protect Range" option. I still get "Define new Range". Why do |
| Re: Lock down your cells with protected ranges | APL+ | 8/9/12 2:45 PM | Yes, based on reports it seems the release is a bit staggered (but I guess this is generally the case). Are you using an Apps account per chance? |
| Re: Lock down your cells with protected ranges | QuadT | 8/9/12 2:54 PM | @Adam Yes. I'm using Google Apps but I've also tried accessing it through a Docs account. As of yet, neither account shows the feature. Hopefully soon. I've got several files in which I'll implement it immediately. |
| Re: Lock down your cells with protected ranges | APL+ | 8/9/12 3:03 PM | Yes I hope it lands for you soon. With Apps there is an administrative setting that affects whether you receive new feature releases or not. But it doesn't explain your personal account. |
| Re: Lock down your cells with protected ranges | QuadT | 8/9/12 3:14 PM | @Adam I looked through my settings in Manage Domain but didn't find anything that would control receiving updates to existing apps. Rather, it only provided control of which apps to provide and whether or not to allow users to determine which apps th |
| Re: Lock down your cells with protected ranges | APL+ | 8/9/12 3:23 PM | Domain Settings, General tab, scroll down to New User Features and you can choose Rapid Release or Scheduled Release. |
| Re: Lock down your cells with protected ranges | QuadT | 8/9/12 3:44 PM | Initial reaction....AWESOME!!! WOOHOO!!! (As bells chime, whistles blow, and confetti falls out of the sky) Contained reaction...thanks Adam. That was exactly what was needed and the result was immediate. Thank you for your assistance! Note to all: I |
| Re: Lock down your cells with protected ranges | Dan Halbert | 8/9/12 6:23 PM | I have noticed the same issue with "visible to anyone with the link". My use case is to prepare a signup sheet (say, who's bringing what for lunch), and protect the fixed parts of the signup sheet. Then I email or post the link to the interested part |
| Re: Lock down your cells with protected ranges | Kevin Ballestrini | 8/10/12 6:37 AM | Issue: master sheet which contains named and protected cells, view only for other users to make a copy. When a copy is made by the user and then that user shares the sheet with a third user, that third user has full edit access to the protected cells |
| Re: Lock down your cells with protected ranges | Teresa C. | 8/10/12 2:10 PM | Thanks for all the feedback - we've passed this on to the team and are looking into the issues you've raised. |
| Re: Lock down your cells with protected ranges | UFO64 | 8/10/12 6:50 PM | Awesome to hear, keep up the good work! |
| Re: Lock down your cells with protected ranges | Len K | 8/11/12 8:28 AM | Also would be useful to protect all cells with a formula, even from owner. Disable protection temporarily to change existing formula. |
| Re: Lock down your cells with protected ranges | Skrumpy | 8/11/12 11:58 AM | I sincerely hope that one of the things passed on is the greying out of protected cells. Depending on certain text color/background combinations the greying out effect essentially makes the underlying text unreadable. |
| Re: Lock down your cells with protected ranges | andretan | 8/12/12 5:20 AM | |
| Re: Lock down your cells with protected ranges | Sourav_Mitul | 8/12/12 11:49 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | Sourav_Mitul | 8/12/12 11:56 AM | |
| Re: Lock down your cells with protected ranges | mumeladder | 8/13/12 10:04 AM | |
| Re: Lock down your cells with protected ranges | badkaren | 8/14/12 11:45 AM | |
| Re: Lock down your cells with protected ranges | DocsRookie | 8/16/12 4:22 AM | |
| Re: Lock down your cells with protected ranges | Arcox | 8/20/12 12:41 AM | |
| Re: Lock down your cells with protected ranges | Kevin Rikys | 8/23/12 3:13 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | Colbyamoss | 8/24/12 7:57 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | cwp321 | 8/25/12 9:56 AM | |
| Re: Lock down your cells with protected ranges | SSwannab | 8/25/12 2:39 PM | |
| Re: Lock down your cells with protected ranges | karenm1122 | 8/27/12 12:13 PM | |
| Re: Lock down your cells with protected ranges | louierocko | 8/28/12 10:58 AM | |
| Re: Lock down your cells with protected ranges | MrNull | 8/29/12 5:22 PM | |
| Re: Lock down your cells with protected ranges | Filipe84 | 8/30/12 7:06 AM | |
| Re: Lock down your cells with protected ranges | Filipe84 | 8/30/12 7:09 AM | |
| Re: Lock down your cells with protected ranges | GeorgeZhao | 9/2/12 5:44 AM | |
| Re: Lock down your cells with protected ranges | MSU Color Guard | 9/2/12 6:51 AM | |
| Re: Lock down your cells with protected ranges | sjk153 | 9/11/12 8:29 AM | |
| Re: Lock down your cells with protected ranges | Persy | 9/11/12 11:37 AM | |
| Re: Lock down your cells with protected ranges | whc23863 | 9/13/12 9:38 AM | |
| Re: Lock down your cells with protected ranges | keepita | 9/18/12 4:45 PM | |
| Re: Lock down your cells with protected ranges | Ramenhaus | 9/19/12 10:06 PM | |
| Re: Lock down your cells with protected ranges | C4R3J | 9/22/12 11:05 PM | |
| Re: Lock down your cells with protected ranges | Chrisnetika | 9/25/12 12:08 AM | |
| Re: Lock down your cells with protected ranges | scorph | 10/5/12 3:56 PM | |
| Re: Lock down your cells with protected ranges | Julian Edward | 10/11/12 8:58 PM | |
| Re: Lock down your cells with protected ranges | ghorning166 | 10/16/12 12:55 PM | |
| Re: Lock down your cells with protected ranges | Carlton Bale | 10/25/12 10:39 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | Carlton Bale | 10/25/12 10:50 AM | |
| Re: Lock down your cells with protected ranges | Eytan Schmal | 10/31/12 2:05 AM | |
| Re: Lock down your cells with protected ranges | Eric Choley | 11/5/12 8:55 AM | |
| Re: Lock down your cells with protected ranges | FrankNL | 11/6/12 3:06 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | FrankNL | 11/6/12 3:08 AM | |
| Re: Lock down your cells with protected ranges | 17teen | 11/6/12 9:55 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | PPSTechM | 11/12/12 10:08 PM | |
| Re: Lock down your cells with protected ranges | --Hyde | 11/13/12 4:53 AM | |
| Re: Lock down your cells with protected ranges | sam91011 | 11/14/12 8:52 AM | |
| Re: Lock down your cells with protected ranges | JTH | 11/15/12 4:12 PM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | JTH | 11/16/12 8:38 AM | |
| Re: Lock down your cells with protected ranges | Tom AUT | 11/29/12 5:48 PM | |
| Re: Lock down your cells with protected ranges | PhungT | 12/2/12 12:26 AM | |
| Re: Lock down your cells with protected ranges | abdulet | 12/16/12 1:03 PM | |
| Re: Lock down your cells with protected ranges | Amy Ruth | 12/23/12 8:18 AM | |
| Re: Lock down your cells with protected ranges | Gill | 12/23/12 10:37 AM | |
| Re: Lock down your cells with protected ranges | Amy Ruth | 12/24/12 7:01 AM | |
| Re: Lock down your cells with protected ranges | Rob Hephner | 12/26/12 2:52 PM | |
| Re: Lock down your cells with protected ranges | Rob Hephner | 12/26/12 3:07 PM | |
| Re: Lock down your cells with protected ranges | Eytan Schmal | 12/26/12 4:58 PM | |
| Re: Lock down your cells with protected ranges | Majeed El Chemor | 12/28/12 1:15 PM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 1/21/13 2:32 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | DAS1951 | 1/21/13 2:41 AM | |
| Re: Lock down your cells with protected ranges | Santi Cazorla | 1/22/13 1:06 AM | |
| Re: Lock down your cells with protected ranges | JTH | 1/23/13 4:07 PM | |
| Re: Lock down your cells with protected ranges | Saechang | 2/28/13 6:05 PM | |
| Re: Lock down your cells with protected ranges | Seth Kazzim | 3/5/13 8:33 AM | |
| Re: Lock down your cells with protected ranges | Seth Kazzim | 3/5/13 8:57 AM | |
| Re: Lock down your cells with protected ranges | Illutian Kade | 3/19/13 11:03 AM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 3/19/13 2:55 PM | |
| Re: Lock down your cells with protected ranges | Christine Foulk | 3/23/13 10:36 PM | |
| Re: Lock down your cells with protected ranges | Illutian Kade | 3/24/13 10:34 AM | |
| Re: Lock down your cells with protected ranges | timjasper | 3/24/13 9:08 PM | |
| Re: Lock down your cells with protected ranges | Brian Fensome | 3/26/13 2:13 AM | |
| Re: Lock down your cells with protected ranges | mustafa atatuzun | 3/26/13 9:17 AM | |
| Re: Lock down your cells with protected ranges | karoune adlane | 5/2/13 5:16 AM | |
| Re: Lock down your cells with protected ranges | karoune adlane | 5/2/13 5:22 AM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/2/13 11:59 AM | <This message has been deleted.> |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/2/13 12:01 PM | |
| Re: Lock down your cells with protected ranges | Mike Freedman | 5/2/13 4:28 PM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/2/13 10:46 PM | |
| Re: Lock down your cells with protected ranges | Si Tavner | 5/3/13 3:23 AM | |
| Re: Lock down your cells with protected ranges | Aaron Hoyle | 5/3/13 4:17 PM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/4/13 12:40 AM | |
| Re: Lock down your cells with protected ranges | Jarrod Medrano | 5/4/13 5:13 PM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/5/13 1:39 AM | |
| Re: Lock down your cells with protected ranges | Jarrod Medrano | 5/5/13 7:57 AM | |
| Re: Lock down your cells with protected ranges | DAS1951 | 5/5/13 12:04 PM | |
| Re: Lock down your cells with protected ranges | Kellyfk | 5/6/13 1:41 PM |