Hello,

I was wondering if i could get a few suggestions.... I'm trying to make a
complex spreadsheet secure.

It is a rating spreadsheet - i.e you put in answers to questions it has on
it - which in turn generates a price depending on what answers you have put
in.

Also, i will need store what has been put in the sheet each time so i can
look back and analyse it at a later date...

What i want to keep secure is:
The rating (from V look up tables) - i was thinking of hiding these sheets
Prevention of copying the whole sheet so they can't steal it only use it.


It will have a small amount of users (say 3-5)...
I was thinking of providing each individual with a front end - which stores
what they put in it each day/week and then writing a macro in another sheet
which gathers all of what they have put in

Also - if i set up the "rating sheet" with everything on it as V look ups
(even description fields) to another workbook (which the users didn't know
about) - if they tried to copy the first sheet without the second - would it
make the first useless?

Would welcome some suggestions/validation of ideas....

Thank you
--
kelly m johnson
London