Macro Help

[Dazed and confused]

I'm not sure if this is the right place for my question,
but here it goes:

I'm working for a company and we need to create some way
to protect a word document in this way - a person "signs"
on a table, then clicks on a macro that protects his
signature as well as the other signature table cells. the
document is then routed to the next person. That next
person clicks on a macro that will unprotect all the
fields, but then immediately protect the last signature to
ensure that this next person will not tamper with previous
or future signatures.

I can create macros that protect various cells, but I
don't know if there's a way to have a macro unprotect a
document.

Thanks for your help - and sorry its so long!!

dnc

 

[jesse]

Yes, your post would be better placed in the VBA area. If
you are very concerned about the integrity of those
signing documents, which seems to be the case after our
discussion yesterday, it may be a better choice to
consider a document management utility, that provides
capability of who opened a document, when, how long
opened, what changes etc. Visual Source Safe for example.

See http://msdn.microsoft.com/ssafe/

jesse

 

[Jezebel]

Don't bother. If you really need to track the signatures, log them
separately to a controlled database or equivalent. There is simply no way to
protect a Word document in any but a trivial sense.