View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kashif Sattar
 
Posts: n/a
Default how to protect multiple worksheets simultaneouslly and not one by

I want to protect all my sheets in a workbook but it takes me very long to
apply password on individual worksheets. I have more than 180 worksheets in
my workbook. I want to make all my sheets read only/hidden formulas and
protected by password so that no body can change unless provides correct
password.

Kindly help because i really need this. Thanks.