View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
guilhaume[_2_] guilhaume[_2_] is offline
external usenet poster
 
Posts: 1
Default unlock workbooksin hundred of excel files

Thx a lot, but I think I didn't explain very well what I wanted to do
:)
It is to say:
have a script that takes out the workbook's protection without havin
to open the excel file with Office and do 'Utils', 'Protection'
'Unprotect the workbook' (problably the menu names are wrong, as I a
french I tested a translation... ;))

in fact I wanted a script like that:

for all the files f in the directory d do
f.unprotectWorkbook()
end

reguard

--
Message posted from http://www.ExcelForum.com