Home

Worksheet protections

Marian_DiCicco
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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies