Can't Group or Ungroup in Protected Cells

[Dupi]

I have a problem with Group and Ungroup. In a protected
rows or columns, I can't do Group and Ungroup. Can anybody
help me with some macros that can resolve this? Thanks a
bunch in advance.

 

[BrianB]

The macro code needs to include a line at the beginning to unprotect th
sheet and another at the end to protect again.

If you do not have the password you cannot do this.

Otherwise I suggest you record a macro of your actions and come back i
you need any further help - copy/paste the code in the message

 

[Dupi]

Hi, Brian.
Thanks for the reply. Can you give me example how to do
it?. I mean .. I'm new to VBA Macros..

What do you mean by include a line?. I tried it, by
putting "_______
or "----" can't help it.

Thanks,