Results 1 to 3 of 3

Thread: Proetection keep you from viewing data in filtered rows.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2018
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Proetection keep you from viewing data in filtered rows.

    So I am using filters to hide data from users.
    Depending on a login password. I un-filter or filter certain rows and then use filter refresh.

    However I guess anyone can link to tab on another sheet or file and then just copy up or down and see the filtered rows.

    Is there a way to stop this?
    Last edited by cogswel__cogs; Sep 16th, 2019 at 05:15 PM.

  2. #2
    Board Regular baitmaster's Avatar
    Join Date
    Mar 2009
    Location
    bristol, england
    Posts
    2,027
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Proetection keep you from viewing data in filtered rows.

    No, sorry

    Excel is not a secure medium and you cannot hide anything from an experienced User. If using it to hold sensitive data - commercial, legally protected, GDPR etc - then you MUST take extra care when sharing it. Consider using VBA to generate subsets of results that get written to new files to share with individual Users
    Baitmaster G



    Always save your work before running code from me, I probably haven't tested it and I'm not responsible when you lose all your work :p
    I aim to improve understanding so you can develop your own solutions, not do all your work for you. Write a clear requirement and you're more likely to get help

  3. #3
    Board Regular
    Join Date
    Jan 2018
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Proetection keep you from viewing data in filtered rows.

    Thanks for reply.
    I figured that was case. It not an uber security issue so I just took name column moved it and only show it in that row if it is in filtered material.

    .

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •