View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Password protecting multiple spreadsheets at once

You need to write a Macro which will loop through all the files in the
specified folder and password protect all files.

Let me know if you want me to write that.

"Ron" wrote:

I have a folder with 8000 spreadsheets, is there a way to PW protect all of
them at once, or will they need to be done manually?
--
Ron