Anyone smarter than me,
I have been asked to create an excel file that can keep track of a lot of information concerning training excercises for the employees of the company. As there are many different sections and many requirements inside those sections, I thought I would make it easier on the person that had to edit the sheet by grouping the requirements in each section together so you could show/hide sections and make the sheet smaller to elimate the need to scroll up and down the huge document. Anyway, I was able to do that fine, now the problem I am facing is that now, I need to protect the sheet and workbook so that no one accidentally changes any of my formulas or requirements. However, when I protect the sheet, all users are now unable to show/hide details of the groups. I have tried various different permissions and things and haven't had any luck. Anyone have any good ideas or references that I can look at?
Thanks,
Danaki
Bookmarks