Edit macro to protect/unprotect multiple sheets


Posted by Dwight on June 14, 2001 2:25 PM

I make frequent use of extremely simple macros to protect or unprotect active worksheet in Excel 97. When I try to do same with myltiple sheets selected, I get an error message that says "Protect method of worksheet class failed". What code can I add to:
"ActiveSheet.Protect" to make it work with multiple sheets?
Thanks.



Posted by Dwight on June 14, 2001 2:28 PM

& perhaps select all sheets as 1st part of macro? EOM