Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-08-2020, 12:22 AM
ArviLaanemets ArviLaanemets is offline Protect cells Windows 8 Protect 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

You can't protect a particular cell only - you have to protect worksheet. But you can determine, how the protection will affect particular cells in this worksheet (is editing allowed, is data validation allowed, are formulas/manually entered values displayed in formula bar, etc.

Select whole worksheet (click at left of 1st column - column A - label). Select Format Cells and activate Protection tab. Set options Locked and Hidden for all cells on worksheet;
Select any range in worksheet you want to follow different protection rules. Select Format Cells and activate Protection tab again. Set rules for this range;
Repeat the process until you protection rules for all needed ranges are set;
From Review menu, select Protect Sheet. At bottom of Protect window, you can allow additional options for locked/unlocked cells in worksheet. Enter password and click OK. you are asked to repeat the password. Optionally you may leave password unfilled.

After you have protected the worksheet, user can edit cells which are unlocked, and he/she can't edit any other cells in worksheet.

There are some protection options, which you can set only using VBA code (I'm not sure about Excel2007, but in older versions the option to set additional allowances when protecting the sheet was not available - you had to do this through VBA only).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to protect cells and still be able to use all data entry form Jae Excel 2 11-13-2019 05:32 PM
How do I un-protect docs I didn't protect? doctorduncan Word 4 05-30-2019 11:09 AM
How can I automatically protect only certain cells in Excel 2010 KelStin Excel 8 03-26-2017 08:00 PM
Protect cells Excel VBA: Worksheet_Change Cells.Protect tinfanide Excel Programming 8 04-08-2012 09:58 PM
Protect / Lock Cells / Print Set-up? meggenm Excel 3 01-26-2012 09:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:38 PM.


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