Solved

password protect a cell in excel 2007

Posted on 2014-02-17
3
374 Views
Last Modified: 2014-02-17
Hi expert's excel 2007

How would you password protect a single cell in a worksheet and leave the remaining cells open for editing.
0
Comment
Question by:route217
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39864256
HI

First select all the cells

Right-click Format cells goto Protection

untick Locked

then do the same with you cell and tick Locked ( so it will be the only Locked)

then to Review Protect Sheet

Add you PW and OK

You could there manage there what are possibilities for the users

Regards
0
 

Author Comment

by:route217
ID: 39864355
Hi rgonzo

Thanks for the feedback...
0
 

Author Comment

by:route217
ID: 39864356
Hi experts

You also provided feedback on this question http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_28364900.html

I can you kindly look at my posting please.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question