Share via

Using password when selecting a slicer

Anonymous
2018-08-17T17:00:14+00:00

Currently, I have a worksheet with slicers where a user selects the product results they wish to review on a pivot located on another worksheet.  Is it possible to ask for a password when a slicer is selected so the user cannot see other product information?

Or does anyone have other recommendations on restricting access to Excel reports based on the user selection?

Purpose is to prevent restricted information from being viewed.

Moved From: Excel / Windows 10 / Office 365 Home

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-08-20T06:51:28+00:00

    Hi,

    Microsoft Excel has built-in options that allow workbooks, worksheets or certain elements in the file to be protected by using a password. Based on our findings, one way the desired output that you would like to see can be achieved is by using macros or VBA scripts in Excel. What we'll do is move this thread to the Microsoft Office programming category so that experts with coding can provide assistance in getting the desired result.

    Feel free to reach out to us for any further concerns.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more