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
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
You could use a user-defined function:
E..g.,Please Login or Register to view this content.
=IF(IsProtected(), "Yup", "Nope")
But changing the protection won't cause the formula to recalculate. It will calculate when you change any cell, though.
Last edited by shg; 11-14-2014 at 06:17 PM.
Entia non sunt multiplicanda sine necessitate
Or you could use the XL4 macro Get.Document(7, "Sheet1")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks