Macro looping for each sheet in workbook
Posted by Susan Golinsky on July 30, 2001 11:01 AM
I have written a macro to unprotect a sheet in a workbook, but need to loop it for each sheet. The macro will be used in various workbooks that each have a different number of sheets. Right now I have inelegantly copied the 2 lines of code more times than could possibly be needed so that it poops out when it gets to the end. I would prefer the elegant approach.
Thank for any suggestions,