Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
 



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 01:32 AM.


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