Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2020, 06:58 AM
otuatail otuatail is offline Protect cells Windows 7 64bit Protect cells Office 2007
Competent Performer
Protect cells
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default Protect cells


How do I protect cells in Excel 2007. I do know that I can encript a document with a password. But that is a password to open the document. I don't want that. I want the user to be able to opwn the document but not protected ones. By default they are protected anyway.


TIA
Reply With Quote
  #2  
Old 12-07-2020, 10:11 AM
Logit Logit is offline Protect cells Windows 10 Protect cells Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Automatically Lock Certain Cells in Excel using a Macro - TeachExcel.com
Reply With Quote
  #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: 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

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
Reply

Thread Tools
Display Modes


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 09:03 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