Protected Worksheet Indication

  • Thread starter Thread starter Steve Klenner
  • Start date Start date
S

Steve Klenner

Is there a way to visually see if a worksheet is protected? The toolbar
will indicate protected cells but I cannot find a way to indicate whether a
worksheet is protect without manually checking.

Is there a formula that can be used in conditional formating of a cell that
could indicate if a worksheet is protected or not. I need a quick way to
know that required worksheets are protected.

Thanks
Steve
 
The following courtesy of JE will toggle protection on every sheet, so if you
only want certain ones protected then do those manually initially, and then use
this to turn protection on/off. It will give you a status of every sheet once
done.


Public Sub ToggleProtect1()
'Courtesy of J E McGimpsey
'If only selected sheets are to be protected, then a toggle works well

Const PWORD As String = "ken"
Dim wkSht As Worksheet
Dim statStr As String

For Each wkSht In ActiveWorkbook.Worksheets
With wkSht
statStr = statStr & vbNewLine & "Sheet " & .Name
If .ProtectContents Then
wkSht.Unprotect Password:=PWORD
statStr = statStr & ": Unprotected"
Else
wkSht.Protect Password:=PWORD
statStr = statStr & ": Protected"
End If
End With
Next wkSht
MsgBox Mid(statStr, 2)
End Sub
 
Alt T P is fast.

One solution is to color code something, a cell or even the whole shee
and remove the color coding when the protection is turned off
 
Don't a lot of the icons on the standard and formatting toolbars get disabled?
 
Investment Quest/partnership

Attn: Sir/Madam,



My name is Dr. Brume Mohammed Al-Khalil and I work with the Ministry of Defence. I am writing you based on my interested in investing into real estate and other businesses in your country.



I have contacted you on the consideration that I could discuss with you on the possibility of placing some funds with you for management either in your existing establishment or other venture to be undertaken at your discretion under terms to be agreed upon and also inquire about the possibility of you handling this investment and management on my behalf in your country.



Please furnish me more information on the availability of the areas of investment that you know and if possible so we can work out modalities to partner together.



Should you be interested in this proposal, kindly state your interest urgently by using bellow email address to email me and I will furnish you with details as soon as I receive your favorable response. If you are not interested in this, kindly keep this information very confidential.



I await a swift response from you as soon as you can.



Regards,



Dr. Brume Mohammed Al-Khalil.

(e-mail address removed)
 
Back
Top