Thread: Is worksheet protected?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Is worksheet protected?
Hi
try
If Worksheets("Sheet1").ProtectContents Then
MsgBox "Sheet1 is protected."
End If


--
Regards
Frank Kabel
Frankfurt, Germany


Kolmyk AE wrote:
How to detect (VBA) is worksheet protected or it is not?

Thank you.
Reply With QuoteReply With Quote