Conceptual/Design Help required

paulyf · Apr 10th, 2002, 04:50 AM

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

Tom Schreiner · Apr 10th, 2002, 04:59 AM

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

paulyf · Apr 10th, 2002, 05:25 AM

Thanks Tom

How do I lock a project for viewing?

Cheers - Paul

Tom Schreiner · Apr 10th, 2002, 05:42 AM

In VBA development environment

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

Have Fun!
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 04:50 AM	#1
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	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

Apr 10th, 2002, 04:59 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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

Apr 10th, 2002, 05:25 AM	#3
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	Thanks Tom How do I lock a project for viewing? Cheers - Paul

Apr 10th, 2002, 05:42 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	In VBA development environment Tools, VBA Project - Project Properties, Protection, Check "Lock for Viewing" Enter a password Have Fun! Tom