Excel vba ungroup specific group with password

[jocker_boy]

Hello,

I have multiples columns group.
Is it possible to protect columns ("E:I") that are grouped and appear a box to insert password when attempting to ungroup columns ("E:I")?

Thanks.
Gonçalo

 

[phillip87]

If you password protect your worksheet it will deny access to grouping and ungrouping as excel does not allow grouping/ungrouping when the sheet is protected, however if you would like to have a password protected sheet and still group/ungroup then use this VBA.

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

 

[jocker_boy]

Thanks for the answer, but it not what i pretend.
I want to be able to use the sheet but only protect columns "C:E" that must be hide, and have the possibilty to unhide this columns with password.