View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Gary is offline
external usenet poster
 
Posts: 143
Default Protect-Unprotect all the sheets

Hi All,

If i have a workbook with 15 or more sheets and i want to protect /
unprotect all of them together. How do I do it? going to every sheet and
doing it takes a lot of time....am sure there must be a way of doing that.

Thanks
gary