Visually show a SHEET'S Protected or Unprotected status.

[DeanExcel]

Hello,

I would like to create a cell that changes colour or displays warning text notifying that the 'SHEET' is currently Protected or Unprotected.

Is there a formula or function that can do this?

Many thanks,
Dean.

[sweep]

Hi,

You could do this with a UDF:

Please Login or Register  to view this content.

Then use =ISSHEETPROTECTED() in your worksheet to give a TRUE or FALSE response.

[DeanExcel]

Hi Sweep,

That works great thanks.

I tweaked the formula =ISSHEETPROTECTED()=FALSE

I used it in a conditional format to change the colour of a cell to notify me that the sheet is 'UN'protected.

IMPORTANT NOTE: (To future readers, the cell colour only changes after an event.)

Many thanks Sweep.
Regards, Dean.

[DeanExcel]

I had another question but deleted it and started a new thread...
http://www.excelforum.com/excel-form...ml#post3990788