Thread
:
EXCEL: Protect a cell depending on another cell value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
external usenet poster
Posts: 219
EXCEL: Protect a cell depending on another cell value
Functions only return information. They can't change an object. You need a
macro to do that.
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"frenchflo" wrote:
Hello
I need a formula to protect a specific cell depending on the value of
another cell. For example, if(A2=0, protect(A3), "")
If A2=0, I do not want anyone to be able to modify in anyway A3
Thanks for your help
Reply With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown