unprotect sheet on all files at the same time

hostelowner

Board Regular
Joined
Apr 19, 2005
Messages
105
If I have 100 files and each one is sheet protected how do I Run unprotect sheet on all excel files (all workbook sheets) for multiple excel files in the same folder.

I want to do this without having to open each excel file and unprotect the worksheets one by one...
thanks I hope this is enough information

regards
mark
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,118,424
Messages
5,572,030
Members
412,434
Latest member
Tawanda K Chakuma
Top