Ed

Yep it sounds as though Im following your footsteps here!
I am just stopping fumblers. All they get on opening is a userform for data
entry.
Dates can only be entered by a button so they cant screw up the date
formatting. Even signing off has to be via a code number so there is no
blaming anyone else. I have even blocked anyone changing recalled
information, The devil in me has set it to allow them to change the text
within the fields and save as usual - what they have not realized is
changed text does not get to the database!!!
Thanks for the links to VeryHidden

Kenny
www.handpicked.co.uk/crathornehall


"Ed" wrote in message
...
"Harlan Grove" wrote in message
...
<<snip
Welcome to Excel development. There is no robust way to protect any
content
stored in any Office application's document files.

I guess it depends on whether you're trying to protect sensitive or
proprietary information from being available to unauthorized hackers, or
simply wanting to prevent fumble-fingered non-thinkers from screwing up
your
data! I created a workbook one time: the visible front sheet was
available
for use as a data input form, while the second sheet was hidden,
collecting
the data and sorting it into a structure the database would easily import.
People kept screwing with the front sheet, which messed up my second
sheet.
Had some frustrated phone calls when they couldn't get through the
password
to make the first sheet "prettier" - but I kept my data input structure
safe!

Ed