Just assume you a worksheet wherein you have few groups for column or rows and then you Protect Excel Worksheet that worksheet. Now will you be able to expand or collapse those groups? No, you cannot expand or collapse it because it will show error as worksheet is protected. Protect Excel Worksheet   If your … Continue reading Protect Excel Worksheet as UserInterFaceOnly