View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Geoff C
 
Posts: n/a
Default Display worksheet protection status in a cell?

My users are working with a worksheet that has protection on most of the
time, but without a password, just to help prevent accidents. It would be
nice if there was a big red cell somewhere that said "Protected" or "Not
protected". Is there a function that can display protection status? If not,
anyone have a good suggestion for achieving this effect?

Thanks,
Geoff.