I have users entering data onto a page, at the end of the page, the page is
password protected to prevent changes. The file needs to be with the user to
view data.

Being a real paranoid ! I want to be able to detect if someone has altered
the data by hacking the password for example.

What i want to do is at the bottom of the page print a certain value which
is directly dependent on the data on the page. E.g No of Characters, No of
vowles, No of bytes of data or something else (unknown to the user), So if
someone was to manipulate the data it can be detected by cross checking
against this value.

Hope i make sense.

Any Sherlock Holmes out there

Sunil

A few thoughts, but no solutions- maybe this will help you think of something.

In workbooks where I need to track activity (and where macros have to be
enabled for the workbook to function properly) I hide a worksheet and every
time the workbook is opened, I save the date/time and the UserID of the
person who opened the file. My workbook is too complex to try to track/save
what was changed, but at least I can track backwards and know who used the
workbook.

If you also set up the workbook_close to save the date/time it was closed,
you could check to see if the workbook had been altered while macros were
disabled; check the value of the last saved date/time document property and
compare that against the one you have saved in the workbook; if the workbook
property is newer than the saved value, then someone modified the workbook
without macros enabled. (they won't always be equal, because someone might go
into the workbook and exit without saving- so just look for a newer value)

If you wanted to calculate a basic checksum (number of characters,
whatever), you could (also using a macro, which requires that macros be
enabled) push your value to a custom document property. Then (also requiring
macros) if the value you calculate when opening the document doesn't match
the expected value (from your custom document property) you could alert the
user. Be careful about using logic that prevents the file from opening if the
values don't match, because testing it will be a pain if you keep locking
yourself out of the file.

If you use Sharepoint, it automatically stores old versions of the workbook
and you can track problems backward and (manually) see exactly what changes
were made between each saved copy, and who saved each copy.

HTH,
Keith

"sunilpatel" wrote:

I have users entering data onto a page, at the end of the page, the page is
password protected to prevent changes. The file needs to be with the user to
view data.

Being a real paranoid ! I want to be able to detect if someone has altered
the data by hacking the password for example.

What i want to do is at the bottom of the page print a certain value which
is directly dependent on the data on the page. E.g No of Characters, No of
vowles, No of bytes of data or something else (unknown to the user), So if
someone was to manipulate the data it can be detected by cross checking
against this value.

Hope i make sense.

Any Sherlock Holmes out there

Sunil