Protect Sheets Macro Fails on Excel Sheets

http://blog.contextures.com/archives/2011/08/24/unprotect-all-excel-sheets/ To quickly and easily protect all the sheets in an Excel file, you can use a simple macro, like the one shown in my blog post, at the link above. However, even a simple macro can run into problems, in some situations. In this video, the Unprotect macro works well the first time, but doesn't unprotect the sheets when we try the macro again. When running the macro, an Error 1004 message appeared. The problem was caused by grouped sheets, which can't be unprotected. A line of code is added to the macro, and the problem is solved.