Group/Ungroup Protected Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ungroup columns in protected sheet 1
How to Protect the sheet, if few of the columns / rows are grouped 1
Macro code mod - add tabs/apply to entire workbook 2
Ungrouping sheet tabs with a Macro 2
Allowing for Grouping and Ungrouping while Sheet is Protected 2
How to ungroup ? 1
group/ungroup 1
Enable grouping in protected worksheet 2

Back
Top