Worksheet protections

Occasional Visitor

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!