View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diddy Diddy is offline
external usenet poster
 
Posts: 155
Default Loop through files in a folder and unprotect sheets

Hi everyone,

Could anyone help me with code for this please.

What I would like to do is to browse to the folder and then loop though each
workbook and turn protection off.

The books I have at the moment all only have one sheet but would it be
possible to code for more than 1 no probs if not

I would be so grateful if anyone could help.

I've been looking at lots of examples online but due to acute inexperience I
haven't been able to put anything together although I have learnt a lot
trying and trying and.....
Many thanks
--
Deirdre