Ungrouping Rows in Protected WorkSheet

So you would like people to be able to use the Group and Ungroup Icons on the sheet to expand but you don't want them to be able to access or change the cells in the rows which are grouped?

Originally Posted by PFDave

So you would like people to be able to use the Group and Ungroup Icons on the sheet to expand but you don't want them to be able to access or change the cells in the rows which are grouped?

Yes and No. I am only grouping and ungrouping the rows for visual and printing purposes. ie, rows 1 to 60 would be page 1, and rows 70 to 120 grouped and page 2. So the user can ungroup the additional rows and enter additional information (in certain unlocked cells and columns) if they need to for page 2.

But not sure why after using the above code when locking the sheet, that it stops working when I reopen the workbook.

I can put this in a workbook open to force it and this will work letting the user ungroup the rows and enter the additional data in the unlocked cells, but it also forces me to put the password in plain text.

Please Login or Register  to view this content.

Well. I ended up just going with the above, but then thought to password protect the actual code. It will keep the average work user from trying to unlock the worksheets. But anyone who really wanted to could just google how to break a vba password pretty easily.