Re: Determine If Allow Edit In Cell Is On/Off Or True/False
You're taking advantage of my stupidity!
Seriously, though, I will re-read ALL the instructions to try to fit in with what you require from a customer.
So sorry that I got off on the wrong foot and am being such a difficult customer!
how you word your post is not really of concern to me, but should be [COLOR="Blue"]to yourself [/COLOR]if you want a decent reply. This tells me I should ask the question to myself, i.e. "How do I use Excel's option settings in a formula?" So far - so good. That's what I did. (More or less!)
Your next advice was, "Your thread title should NEVER be what you THINK is your answer. 9 times out 10 it will [be] wrong and prevent someone from finding a solution to a simliar issue." Thankfully, Andy latched onto my question quickly and supplied an answer VERY quickly. Thank you very much, Andy! ( a friend of mine, from southern England, is in Kandahar, Afghanistan now, but I digress!)
Finally, Dave, your response does not address the fact that Andy added to, and opened up, a whole new dimension to the original question. Please reflect Andy's input in the title of the post. Otherwise, future searchs will be directed to nowhere! (How many visitors need to know the present subject of your new title?)
Dave, so sorry for being such a sn__ on this item, but ........................
Dave (in eastern Canada)
CQM/OE (Certified Quality Manager/Organizational Excellence)[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Hi Andy:
Further to the use of the User Defined Function, udfEditInCell(), that you suggested, the answer, TRUE or FALSE, will not update itself unless I press F2 to edit the cell and then press Enter. I checked the Calculation mode and it IS set to Automatic.
Why is the function not calculating by itself?
Regards, ..... Dave