unprotect a sheet with VBA

[Mick S]

I have about 100 files (each one sheet) that I have built a macro to do various thins to. I got through 50 of them only to find that the remaining 50 have been protected by the originator of the files. There is no password involved, they are simply protected. what code do i use in the beginning of my macro to automatically unprotect the sheets so the macro can run?

[tlafferty]

Try this code:

Please Login or Register  to view this content.