I have a protected worksheet but I need to allow the user to use the group and ungroup functions. How do I do this?
I have a protected worksheet but I need to allow the user to use the group and ungroup functions. How do I do this?
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.
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.
Be as you wish to seem
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).
_________________________________________________________________________
"In theory there is no difference between theory and practice. In practice there is." - Chuck Reid
Any day you learn something new is a day not wasted.