Firstly, there is no such thing as 100% security. What can be coded can be
decoded. Remember, during WW2, the Germans thought their codes could not be
cracked and, to make matters worse, couldn't accept evidence that their
codes were being cracked.

The first level of security is to password protect your spreadsheet. This
would, at least ensure that a casual browser could not open your
spreadsheet. However, it doesn't prevent a casual browser looking at the
spreadsheet over your shoulder or whilst available on an unattended monitor.
This doesn't have to be a physical (personal) browse. With unsecured
wireless networking the browse could be from outside the building. To
someone interested enough in the information password protection can be
cracked within minutes so don't rely on it.

Another way of securing information is to use a password manager. A1
Roboform Pro and Keepass Password Safe received a good rating from PCPro
recently. Even with these you have to be careful to not 'leave the key in
the front door'.

On another level.it is very important to make sure that Windows and threat
prevention software (?Norton) is kept up to date on a daily basis in order
to maximise your protection from attack over the Internet.

Regards.

Bill Ridgeway
Computer Solutions

"Kelly 1st" wrote in message
...
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