PC Review


Reply
Thread Tools Rate Thread

Cell formula protection

 
 
=?Utf-8?B?Qm9lbmVyZ2U=?=
Guest
Posts: n/a
 
      23rd Dec 2005
Is it possible to be able to protect a cell formula, but allow information to
be entered or deleted without the formula being deleted as well?
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      23rd Dec 2005
A cell can contain a formula or a value--not both (which should be used???).

But...

How about using a couple of helper cells?

Use A3 for the formula
Use B3 for the user input
Use C3 to determine which should be used:

=if(b3="",a3,b3)

Boenerge wrote:
>
> Is it possible to be able to protect a cell formula, but allow information to
> be entered or deleted without the formula being deleted as well?


--

Dave Peterson
 
Reply With Quote
 
Trevor Shuttleworth
Guest
Posts: n/a
 
      23rd Dec 2005
No

a cell can contain one thing only which could be static data, like a number
or a name, or a formula, or a link to another cell (which I guess is a
formula)

You enter something in the cell, it overwrites whatever was there.

Regards

Trevor


"Boenerge" <(E-Mail Removed)> wrote in message
news:FAA1CA8A-1966-4D3A-A8CA-(E-Mail Removed)...
> Is it possible to be able to protect a cell formula, but allow information
> to
> be entered or deleted without the formula being deleted as well?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password Protection - paste to unprotected cell locks the cell =?Utf-8?B?SmltYm9i?= Microsoft Excel Misc 7 7th Sep 2007 06:22 PM
Cell Protection vs. Worksheet Protection =?Utf-8?B?a213aGl0dA==?= Microsoft Excel Misc 4 24th Sep 2006 02:37 AM
cell protection based on a formula =?Utf-8?B?QUpQZW5kcmFnb24=?= Microsoft Excel Worksheet Functions 0 26th Feb 2006 09:16 AM
Cell protection after entering formula. =?Utf-8?B?QXNob2sgU2FibmU=?= Microsoft Excel Misc 2 18th Jun 2004 01:19 PM
Formula protection Shaya Microsoft Excel Worksheet Functions 0 29th Aug 2003 02:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:12 PM.