View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Determine if a sheet is protected?

Try

activesheet.protectcontents

HTH

Bob

"Robert Crandal" wrote in message
...
How can I determine if a sheet is protected or not?

thank u