PDA

View Full Version : Allow Group/Ungroup on protected sheet



ChuckDickson
06-06-2012, 04:09 PM
I have a protected worksheet but I need to allow the user to use the group and ungroup functions. How do I do this?

fredlo2010
06-06-2012, 04:33 PM
I will follow this post. I have been trying to do this for ages.

I think this cannot be done. But I lets see if we can get an answer here. :)

Aflatoon
06-07-2012, 12:57 AM
If you already have the grouping set up, you can allow users to use the show/hide buttons but you can't allow them to add grouping to a protected sheet.

Teeroy
06-08-2012, 03:27 AM
You can set up subs to unprotect the sheet and protect the sheet. Call the unprotect sub, do the group/ungroup via code, call the protect sub. You should even be able to pass a change to the group via selection if you allow the user to select locked cells. The only downside is the need to hard code the password but this could be possibly overcome by storing it in a custom document property (I really haven't found the need to do it though).