Grouping/Ungrouping protected sheets with VBA

**Stormdronk** · 08-03-2011, 10:51 PM

Hi all

Hope someone can help. I am working on a sheet with VBA but cant get it to work. This is my first trie with VBA.

I need to be able to group/ungroup rows in a sheet when it is protected. All sheets needs to have the code. My password will be lets say "Stormdronk"

Hope this is clear, thanks so much for the help!!!

**gjlindn** · 08-03-2011, 11:02 PM

You probably want this in the WorkBook object (ThisWorkbook in your VBE).

Please Login or Register  to view this content.

The workbook open event will only run from the workbook object (ThisWorkbook). Good luck!

**Stormdronk** · 08-03-2011, 11:21 PM

Hi Greg,

Thanks for the code, unfortunately I cant get it to work, I attached my file with the code in.

If posible, please can you see if you can correct it.

Thanks in advance!!!

**gjlindn** · 08-03-2011, 11:27 PM

Here it is...I didn't add any passwords. I only used the existing code you had written. Good luck!

**Stormdronk** · 08-04-2011, 05:16 AM

Thanks so much, it workes grate!!! Apreciate the help!

**berto** · 09-10-2011, 12:52 AM

I've been trying to use the same solution but I cannot make it work.
Can you also please help me make it work?
I attached my sample spreadsheet.
Thanks.

**berto** · 09-10-2011, 02:12 AM

I did not immediately noticed the important note:
The workbook open event will only run from the workbook object (ThisWorkbook).

My spreadsheet is now working fine.
Thanks.