I have a protected worksheet, and users are to access certain cells. There is also a pivot table to the right of my data.
- Those columns that are most relevant are displayed, while less relevant columns are grouped and collapsed. I need the user to be able to expand and view the collapsed/hidden columns.
- Once the user has selected values for the cells they are to edit, they need to see updated results in the pivot.
- Users should not be able to do anything other than edit unlocked cells, expand and view the collapsed columns, and refresh the pivot.
Can I enable such permissions in a protected worksheet/workbook? If so, how? I have experimented with the protect worksheet options, but no luck there. . . . I am not advanced enough to work with VBA for my solution. . . :(
Please help or tell me it just can't be done...set me free!
