Hi All,
Things that I was trying to achieve
- Enable full access to certain users only based on user login ID. Limited access for the rest of users.
- Users with limited access can only select maximum 5 items in slicer. When it hits more than 5, an error message should show up and (ideally) the last selected slicer item should be deselect. It can also be - clear all selected items and select only one item (any item) in the slicer. My ultimate goal is to stop limited access user to select more than 5 items at once.
I managed to do the first one but stuck at the second one. I couldn't use "undo" because apparently selecting an item in slicer does not consider as an action to Excel. Hence if user don't have any last action in excel, he/she will be prompted error and it does not deselect the last selected slicer item.
Can anyone help me with this?
Bookmarks