I have column B with this formula =IF(C4,WEEKDAY(C4),"") where the reference value goes from C4 to C999
This formula works great to pick the day-of-week
I want to prohibit the user from entering TUESDAY and thus wiping-out my formula
I have several macro's on the sheet / workbook
I have not had any luck in unprotecting-protecting the sheet/workbook within a macro
I guess I've spent 4 hours trying code from this, and other, forums.
So I'm wondering if I can use DATA VALIDATION to do the job?
There is an "in list" function ... is there a way to modify it to be "not in list" ??
-OR-
can I use custom-formula to somehow require what they enter to begin with "=IF(" ??
Thanks
Puzzled-in-St. Louis
Bookmarks