View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adehart adehart is offline
external usenet poster
 
Posts: 2
Default Workbook Protection

Is there a way, through Windows Explorer to unprotect a whole directory of
password protected workbooks? I have a macro that will protect, save and
close each workbook but I still have to open each one to run it. Can I
somehow do it through windows explorer? Or, is there a way to make a macro
written in personal.xls run when a workbook is opened?