Using a Macro on a grouped protected worksheet

[drebbeck]

I am trying to use a macro on a grouped password protected worksheet. The macro is to Group and un group specific parts of the worksheet, unfortunately it will not work as it requires the worksheet to be unprotected. I do not want to unprotect the worksheet as this document will be for other people to use.

Can anybody help please.

Thanks

 

[Stormseed]

You can Protect and Unprotect your worksheet in the macro itself. Like this:

Sheets("Sheet1").Unprotect Password:="xyz"

'your entire macro code goes here

Sheets("Sheet1").Protect Password:="xyz"

 

[drebbeck]

Thanks for that. That works for the macro and password, but the macro was to group and ungroup specific parts of the worksheet. The macro worked but the grouping didn't.

 

[Stormseed]

What are you doing exactly ? Could you please go into a bit of details ?