Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conceptual/Design Help required

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Paul
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi All

    I currently have a worksheet with 300 rows of data, one line per customer. I would like to e-mail this to each customer, restricting their access to the row relevant to their organisation. They must not have access to other rows, nor must any solution be easily circumvented.

    Any thoughts on how this process can be automated??

    Many Thanks

    Cheers - Paul

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Give the sheet a coded name, make it invisible, give your customer a password or id, associate this number with the row they are to have access to, create a userform which will prompt them for the password, return the row of data however you wish.
    Make sure the project is locked for viewing.

    Seems like a lot of work for 300 rows?
    Have you considered other alternatives or are there litigating circumstances here?

    Tom

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Paul
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tom

    How do I lock a project for viewing?

    Cheers - Paul

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In VBA development environment

    Tools,
    VBA Project - Project Properties,
    Protection,
    Check "Lock for Viewing"
    Enter a password

    Have Fun!
    Tom

Some videos you may like

User Tag List

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
  •