Is it possible to use macros to bulk group and ungroup in password protected sheet?

[kbranostano]

Hi everyone,
I have a password protected spreadsheet that I can easily group and ungroup while it is protected.
I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1.
Is this possible?
Thanks,
K

 

[eiloken]

Hi everyone,
I have a password protected spreadsheet that I can easily group and ungroup while it is protected.
I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1.
Is this possible?
Thanks,
K

you can unprotect worksheet to do your thing and protect it after done

Sub group_ungroup()
    ActiveSheet.Unprotect "Your password"
    'your code
    ActiveSheet.Protect "Your password"
End Sub