M
mellowe
HI All
I have a worksheet that has some grouped cells that I would like to
user to be able to expand and collapse and edit when the worksheet is
protected but I can seem to find how to do this.
In my macro I have set up to unlock and lock the worksheet and certain
cells when I need it,and it has the conditions of the protection set up
e.g AllowFilters, AllowSorting but I cant see how to Allow the expand /
collapse / edit of the grouped cells! My grouped range is F12:G40
Please help as I have spent ages trying to find this! Thnx
I have a worksheet that has some grouped cells that I would like to
user to be able to expand and collapse and edit when the worksheet is
protected but I can seem to find how to do this.
In my macro I have set up to unlock and lock the worksheet and certain
cells when I need it,and it has the conditions of the protection set up
e.g AllowFilters, AllowSorting but I cant see how to Allow the expand /
collapse / edit of the grouped cells! My grouped range is F12:G40
Please help as I have spent ages trying to find this! Thnx