VBA for grouping and outlining
Posted by Robert B on September 16, 2001 8:26 PM
I have found that when protection is switched on, collapsing and expanding the cells is not possible. Thus I had thought that could a VBA be written that allows sheets that are already protected to be automatically unprotected and expanded n subsequently protected again whenever the "1", "2" etc buttons or the +/- buttons are pressed. Could someone advise as to whether this is possible and probably the VBA code to achieve this. Thanks.