Hi,
I have a sheet that is locked (by macro) and distributed to users. Some of the rows in the sheet are grouped together. The problem is that, if the sheet is locked, the user cannot expand/contract the grouped rows.
Is there a way using macro/VB code so that user can expand/contract the grouped rows while the sheet is locked.
Thanks.
Bhavesh
Bookmarks