Is something like IF(Worksheet=Protected, "X", "Y") possible?

**ewartha** · 11-14-2014, 05:51 PM

Hello,
for a given cell, I want to display "TEXT-A" if the worksheet is protected, and "TEXT-B" if the worksheet is not protected. Is there a logical_test for determining if the worksheet is protected or not?

Thanks,
Ed

**shg** · 11-14-2014, 05:58 PM

You could use a user-defined function:

Please Login or Register  to view this content.

E..g.,

=IF(IsProtected(), "Yup", "Nope")

But changing the protection won't cause the formula to recalculate. It will calculate when you change any cell, though.

**shg** · 11-14-2014, 08:02 PM

Or you could use the XL4 macro Get.Document(7, "Sheet1")

Is something like IF(Worksheet=Protected, "X", "Y") possible?

LinkBack

Thread Tools

Rate This Thread

Display

Is something like IF(Worksheet=Protected, "X", "Y") possible?

Re: Is something like IF(Worksheet=Protected, "X", "Y") possible?

Re: Is something like IF(Worksheet=Protected, "X", "Y") possible?

Thread Information

Users Browsing this Thread

Similar Threads

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] How to USE """"" cells count """"" change font color

Formula returning result of "True" or "False" instead of "1" or "0"

HELP on "left","right","find","len","substitute" functions

Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next

Bookmarks

Bookmarks

Posting Permissions