View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Gorha Chris Gorha is offline
external usenet poster
 
Posts: 1
Default Detect Password Protection on a Sheet

Hi,

does anyone know how to detect whether a sheet is Password
Protected as opposed to just Protected.

I do this by writing a function and returning true when I
attempt to unprotect it using an "on error". There must be
a better way...

Chris