ExcelBanter - Protected Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protected Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/190159-protected-sheet.html)

I'd like to show some sort of indication on one sheet if a different sheet is
protected or not. Is there an "IF" function for this?

There is no built in function in XL that will tell you whether a sheet is
protected or not. With VBA you could write a function that would give you
that info. That being said there are certain limitations to such a function
since changing the protection on a worksheet does not fire off a calculation.

So in short. Nothing built in and anything you create via VBA will be
marginal at best.
--
HTH...

Jim Thomlinson

"DonB" wrote:

I'd like to show some sort of indication on one sheet if a different sheet is
protected or not. Is there an "IF" function for this?

you could use the attached function:

Function Is_Worksheet_Protected(CellRef As Range) As Boolean
Application.Volatile
If CellRef.Parent.ProtectContents Then x = True
If CellRef.Parent.ProtectDrawingObjects Then x = True
If CellRef.Parent.ProtectScenarios Then x = True

Is_Worksheet_Protected = x

End Function

On Jun 5, 12:03 pm, DonB wrote:
I'd like to show some sort of indication on one sheet if a different sheet is
protected or not. Is there an "IF" function for this?