Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

How to protect cell with formula from being entering info

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TSK - 07 May 2008 02:11 GMT
Can someone advise how can I protect the cell which contain formual and I
know excel had a function to uncolor the cell when result is being calculate.

Example

Formula in cell A3 with Blue Color ==> A1 + A2

Result required
When I key in no. in A1 & A2, A3 will show the result and blue color is
disappeared and A3 do not allow user in anything
Arvi Laanemets - 07 May 2008 06:30 GMT
Hi

Select cell/cell range;
Select Format Cells from menu or from drop-down opened by right-click;
On Protection tab of Format Cells window set protection options:
   Locked - cell contents will be protected when selected.
   Hidden - user will see only results instead of formulas. Nothing is
displayed  in formula bar when the cell is selected, or in edit mode.

Protection setings will work only when the sheet is protected. When the
sheet is unprotected, the user can edit any entries without any
restrictions.
My advice is to select at start the whole sheet, and set main protection
options. After that, select ranges where you want different protection
options, and reset them.

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

> Can someone advise how can I protect the cell which contain formual and I
> know excel had a function to uncolor the cell when result is being
[quoted text clipped - 7 lines]
> When I key in no. in A1 & A2, A3 will show the result and blue color is
> disappeared and A3 do not allow user in anything
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.