Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2017, 08:02 AM
melvin1942 melvin1942 is offline Locking cells Windows 10 Locking cells Office 2007
Advanced Beginner
Locking cells
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default Locking cells

I am wanting to lock a cell. I asked for help and got an answer, I followed the direction that I got, but when I try to lock a cell it seems as though it did not work. I can still change what is in the cell. Do you have to protect the whole sheet for it to work? If I protect the sheet does this keep a person from entering anything in unprotected cells? Can I lock a cell by itself?

Thank you for your time.

Melvin1942
Reply With Quote
  #2  
Old 07-13-2017, 09:39 AM
ArviLaanemets ArviLaanemets is offline Locking cells Windows 8 Locking cells Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by melvin1942 View Post
I am wanting to lock a cell. I asked for help and got an answer, I followed the direction that I got, but when I try to lock a cell it seems as though it did not work. I can still change what is in the cell. Do you have to protect the whole sheet for it to work?Melvin1942
Yes, you have to protect the sheet.

Quote:
Originally Posted by melvin1942 View Post
If I protect the sheet does this keep a person from entering anything in unprotected cells?
No user can change cells with Locked checked. Any user can change cells with Locked unchecked.

Quote:
Originally Posted by melvin1942 View Post
Can I lock a cell by itself?Melvin1942
Reply With Quote
  #3  
Old 07-13-2017, 01:58 PM
melvin1942 melvin1942 is offline Locking cells Windows 10 Locking cells Office 2007
Advanced Beginner
Locking cells
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default

Do you need to lock the cells before you protect the sheet, or protect the sheet and then lock the cells?
Reply With Quote
  #4  
Old 07-13-2017, 10:58 PM
ArviLaanemets ArviLaanemets is offline Locking cells Windows 8 Locking cells Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by melvin1942 View Post
Do you need to lock the cells before you protect the sheet, or protect the sheet and then lock the cells?
Step 1: Set cell formats (check/uncheck Locked and/or Hidden on cell Protection tab)
Step 2: Protect sheet (when you want for users restrict removing protection, then with password - but don't then forget it).
Reply With Quote
  #5  
Old 07-18-2017, 02:00 PM
melvin1942 melvin1942 is offline Locking cells Windows 10 Locking cells Office 2007
Advanced Beginner
Locking cells
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default

What I want to be able to do is lock a cell so it cannot be changed and still be able to work in unlocked cells. What good is it if you lock a cell and cannot work in a unlocked cell because the sheet is protected? If you do not protect the sheet than you can also work in what should be locked cells. If this cannot be done then Microsoft should fix it so you can.

Melvin1942
Reply With Quote
  #6  
Old 07-18-2017, 10:30 PM
ArviLaanemets ArviLaanemets is offline Locking cells Windows 8 Locking cells Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by melvin1942 View Post
What I want to be able to do is lock a cell so it cannot be changed and still be able to work in unlocked cells. What good is it if you lock a cell and cannot work in a unlocked cell because the sheet is protected? If you do not protect the sheet than you can also work in what should be locked cells. If this cannot be done then Microsoft should fix it so you can.

Melvin1942
Did you unlock these other cells before protecting the sheet?

By default all cells are locked, so when you protect the sheet without changing formatting, you can't change anything on this sheet. Likely your course of action must be:

1. Unprotect the worksheet (in case it is protected currently);

2. Select entire worksheet (click on rectangle at top left on sheet);

3. Set all cells on worksheet unprotected (Format Cells: uncheck Locked);

4. Select cell/range of cells you want to restrict user changes for;

5. Set cell/range of cells protected (Format Cells: check Locked);

6. Repeat 5. - 6. until you have set protection for all cells you need to be protected;

7. Protect the worksheet.

In case you need to change previously formatted locking on worksheet, where you want most of worksheet locked, and only some cells unlocked, the order of seting Locked/Unlocked will be reverse.
Reply With Quote
  #7  
Old 07-18-2017, 11:42 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Locking cells Windows 7 64bit Locking cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

This thread is extracted from https://www.msofficeforums.com/excel...-access-2.html
Please do not hi-jack threads. Start one of your own and add a link if necessary.
@Arvi
Please do not quote entire posts unnecessarily. They make threads hard to read. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking cells format changes after locking cells dlquinte Excel 2 04-21-2016 08:31 AM
Locking a Header mramkissoon Word 2 01-14-2016 04:27 PM
Locking cells locking word table cells while auto-updating fields fingermouse Word 6 01-14-2015 06:22 AM
locking out word joe Word 0 11-19-2009 02:09 AM
Locking Text Boise User Word 0 01-24-2009 01:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft