Protection Status of the selected tab in a cell (A1) - Formula, Not VBA

[matthec2]

Hi all,

Without using VBA (i already know the solution here but wondered if there is a quicker formula/function solution), I want to show in a cell on the selected tab, the protection status of that tab.

So for example when the sheet is protected, Cell A1 will say LOCKED
And when when the sheet is unprotected the cell changes to UNLOCKED.

I've just worked out how to use a function to put the tab name in a cell (very useful for indirect formulas!) so wondered if there is a similar function to get the tab protection status.

Thanks!

 

[Fluff]

You could use an old excel4macro function.
create a defined name in the name manager (I called it Status) using

=GET.DOCUMENT(7)&T(NOW())

then in the sheet you can use

=IF(Status="TRUE","Locked","Unlocked")

However this will not change automatically when the sheet is un/locked. It will only change when something else changes or re-calculates.