View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_503_] Simon Lloyd[_503_] is offline
external usenet poster
 
Posts: 1
Default Group/Ungroup Protected Sheets

Hi ive been told that its not possible to protect/unprotect a group yo
have to have the protection loop through each sheet!

Like this..... For Each sh In ActiveWorkbook.Worksheets
sh.Unprotect
Next

Put this statement after your Sheets Array selection.

Hope this helps!

Simo

--
Message posted from http://www.ExcelForum.com