Thread: Determine if a sheet is protected?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Determine if a sheet is protected?
Sub test()

MsgBox ActiveSheet.ProtectionMode 'returns true or false

End Sub


Gord Dibben MS Excel MVP

On Mon, 18 Jan 2010 16:28:18 -0700, "Robert Crandal"
wrote:

How can I determine if a sheet is protected or not?

thank u


Reply With QuoteReply With Quote