Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Locking cells
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 932
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
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
 

« Previous Thread | Next Thread »


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:04 PM.

Contact Us - Privacy Statement - Top

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