VBA to apply different passwords to allow grouping and ungrouping of selected cells

[phillip87]

I have a locked worksheet with the below VBA to allow people to group/ungroup while not being able to change the data. However I now want to take this a step further and password protect each group so departments can only view their own data within the protected sheet.

The data is grouped vertically and horizontally.
11 groups of 16 rows down the side, A4-A18, A19-A37 etc.
5 groups of of 11 columns at the top, F-P, Q-AA, AB-AL etc.



Private Sub Workbook_Open( )
With Sheet1
.Protect Password:="Secret", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub

 

[Jeffrey Mahoney]

I've done similar. You're going to have to control the grouping through macros after the user enters a password. I would store the passwords in VBA and password protect the VBA project. Each password entered is tested and then the groups are selected to be displayed. I would have a macro run that hides all the groups when the last user closes the workbook.

 

[phillip87]

I've done similar. You're going to have to control the grouping through macros after the user enters a password. I would store the passwords in VBA and password protect the VBA project. Each password entered is tested and then the groups are selected to be displayed. I would have a macro run that hides all the groups when the last user closes the workbook.

That's what I was thinking but I am not the best with formatting VBA though I can read and understand it, I have been looking for some VBA code today but have not been able to find any really

 

[Jeffrey Mahoney]

This is a lot ow work. Some hand holding once you get some code and I can't work without your workbook or an example.

Kinda late tonight