Excel: Can't set user-specific editable ranges in protected sheetExcel: lock sheet, but keep tables...
Delete multiple columns using awk or sed
What to do when eye contact makes your coworker uncomfortable?
What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?
Giving feedback to someone without sounding prejudiced
Creating two special characters
Did the UK lift the requirement for registering SIM cards?
Multiplicative persistence
Why do ¬, ∀ and ∃ have the same precedence?
What is the highest possible scrabble score for placing a single tile
"It doesn't matter" or "it won't matter"?
How would you translate "more" for use as an interface button?
C++ copy constructor called at return
Is it allowed to activate the ability of multiple planeswalkers in a single turn?
Is there a RAID 0 Equivalent for RAM?
Which Article Helped Get Rid of Technobabble in RPGs?
Can you use Vicious Mockery to win an argument or gain favours?
Why is the Sun approximated as a black body at ~ 5800 K?
Can I say "fingers" when referring to toes?
Why should universal income be universal?
awk assign to multiple variables at once
Why is so much work done on numerical verification of the Riemann Hypothesis?
Is there a nicer/politer/more positive alternative for "negates"?
I found an audio circuit and I built it just fine, but I find it a bit too quiet. How do I amplify the output so that it is a bit louder?
Which was the first story featuring espers?
Excel: Can't set user-specific editable ranges in protected sheet
Excel: lock sheet, but keep tables expandableProtect formatting in Excel 2010, and allow editing of textBuild a lookup query in Excel using named ranges stored in a cellHow do you permanently unprotect a workbook in Excel 2010?Excel - use both comma and dot to separate decimalsAdd rows to a password protected excel sheet, without the passwordExcel: Let Users Click, but Not Edit, Locked CellsUse drop down in a protected cell Microsoft Excel 2016Excel Allow Users to Edit Ranges : How to change locked cells in a range to unlocked once paasword for the edit range is enteredProtect cells from having data pasted into them, but allow manual entry of new data
I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire spreadsheet. Which should be easy given that it appears to be an explicit excel feature
So I define a range using the 'Allow Users to Edit Ranges' button and give it a memorable title. I set a password AND pick myself from the list of users AND my computer from the list of computers. I check that 'Allow to edit range without password' is set for both in 'Permissions'.
My problem is that despite doing all this, once I lock the spreadsheet, it feels just as locked to me as it would to any other user. If I click any cell in the the range, I cannot mark it. If I double-click a cell - any cell, regardless of whether it's in the range or not - I get the customary Cell is Protected message.
I would expect the cells in the range to simply be editable to me/my computer, or at the least that doubleclicking would prompt me for the 'permission to edit range' password (not to be confused with the 'unlock entire spreadsheet' password).
Can anybody tell me what I'm doing wrong?
microsoft-excel microsoft-excel-2010 lock
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire spreadsheet. Which should be easy given that it appears to be an explicit excel feature
So I define a range using the 'Allow Users to Edit Ranges' button and give it a memorable title. I set a password AND pick myself from the list of users AND my computer from the list of computers. I check that 'Allow to edit range without password' is set for both in 'Permissions'.
My problem is that despite doing all this, once I lock the spreadsheet, it feels just as locked to me as it would to any other user. If I click any cell in the the range, I cannot mark it. If I double-click a cell - any cell, regardless of whether it's in the range or not - I get the customary Cell is Protected message.
I would expect the cells in the range to simply be editable to me/my computer, or at the least that doubleclicking would prompt me for the 'permission to edit range' password (not to be confused with the 'unlock entire spreadsheet' password).
Can anybody tell me what I'm doing wrong?
microsoft-excel microsoft-excel-2010 lock
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire spreadsheet. Which should be easy given that it appears to be an explicit excel feature
So I define a range using the 'Allow Users to Edit Ranges' button and give it a memorable title. I set a password AND pick myself from the list of users AND my computer from the list of computers. I check that 'Allow to edit range without password' is set for both in 'Permissions'.
My problem is that despite doing all this, once I lock the spreadsheet, it feels just as locked to me as it would to any other user. If I click any cell in the the range, I cannot mark it. If I double-click a cell - any cell, regardless of whether it's in the range or not - I get the customary Cell is Protected message.
I would expect the cells in the range to simply be editable to me/my computer, or at the least that doubleclicking would prompt me for the 'permission to edit range' password (not to be confused with the 'unlock entire spreadsheet' password).
Can anybody tell me what I'm doing wrong?
microsoft-excel microsoft-excel-2010 lock
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire spreadsheet. Which should be easy given that it appears to be an explicit excel feature
So I define a range using the 'Allow Users to Edit Ranges' button and give it a memorable title. I set a password AND pick myself from the list of users AND my computer from the list of computers. I check that 'Allow to edit range without password' is set for both in 'Permissions'.
My problem is that despite doing all this, once I lock the spreadsheet, it feels just as locked to me as it would to any other user. If I click any cell in the the range, I cannot mark it. If I double-click a cell - any cell, regardless of whether it's in the range or not - I get the customary Cell is Protected message.
I would expect the cells in the range to simply be editable to me/my computer, or at the least that doubleclicking would prompt me for the 'permission to edit range' password (not to be confused with the 'unlock entire spreadsheet' password).
Can anybody tell me what I'm doing wrong?
microsoft-excel microsoft-excel-2010 lock
microsoft-excel microsoft-excel-2010 lock
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
asked Aug 7 '14 at 12:36
brokkrbrokkr
1549
1549
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 4 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
See this explanation for 2007.
You want to be quite specific with the cells that get locked. If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f793714%2fexcel-cant-set-user-specific-editable-ranges-in-protected-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
See this explanation for 2007.
You want to be quite specific with the cells that get locked. If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
add a comment |
See this explanation for 2007.
You want to be quite specific with the cells that get locked. If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
add a comment |
See this explanation for 2007.
You want to be quite specific with the cells that get locked. If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
See this explanation for 2007.
You want to be quite specific with the cells that get locked. If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
answered Aug 7 '14 at 13:18
doggyTourettesdoggyTourettes
13615
13615
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
add a comment |
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
Your link is the same as the one I linked to myself. To quote it: "To give specific users permission to edit ranges in a protected worksheet ..." reads to me very much like an override of the 'lock' system for a subset of users, no?
– brokkr
Aug 7 '14 at 13:33
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
It gives explicit instructions on how to achieve what you're asking for. You shouldn't be 'locking' the worksheet after you finish your permissions, just the cell ranges you want locked. Locking the worksheet gives you the results you are getting.
– doggyTourettes
Aug 7 '14 at 20:07
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f793714%2fexcel-cant-set-user-specific-editable-ranges-in-protected-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
