Group/Ungroup Protected Sheets

M

Metallo

Hi,

Do you know a simple way to have the Group/Ungroup funtion to work even if the worksheet is protected?

I use Office 2000

Thank you
Alex
 
S

Simon Lloyd

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
 
Top