This video shows you how to write a macro that protects all sheets in a workbook. It also shows you how to create a macro to unprotect those sheets. For the code visit http://www.bluepecantraining.com/portfolio/vba-macro-to-protect-all-worksheets-in-an-excel-workbook/
------------------------