Re: Alternative to macros for creating menu-driven functions?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Graham Mayor (gmayor_at_DELETECAPSmvps.org)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 12:46:46 +0200

Put a password on the protection so that it cannot be unprotected
accidentally. There is nothing to stop the user inserting the form into a
new document to remove the protection, but this then becomes more than an
'accident'.

If you want to deter editing once the form is completed and shipped out,
then output to PDF (you'll need more software) and send the PDF version.
This will fix it for all but the most determined. 

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Widmer wrote:
>> Don't save the macros in the document. Save them in the document
>> template. If they are not in the document, they will not be mailed
>> with it.
>
> Thank you, your advice helped fix my e-mail problem.
>
> Now I need to solve a field resetting problem:
> In the template, I have included macros which prevent the fields from
> resetting when the doc is protected/unprotected, by the user or from
> other template macro code. I got the code here:
> http://word.mvps.org/FAQs/MacrosVBA/TurnFmFlfResetOff.htm . This
> means that if we, for example, send our doc to a lawyer to be edited,
> the macro is no longer with the doc. If s/he clicks on
> unprotect/protect (for any reason, including an accident), all the
> text in the fields will reset. I'd like to save the file as formatted
> text only, without saving the fields themselves in order to prevent
> the fields from resetting. Is this possible or is there a better
> known solution?

Relevant Pages

  • Re: File gets password added after printing...automatically
    ... happen without macros enabled (it's a company template with many macros). ... > unlikely if file level pw protection is being applied. ... > password protection or are the documents being set as "Read Only"? ...
    (microsoft.public.word.docmanagement)
  • Re: Living Forever (Poll)
    ... magically charged by accident and causes super-magic allergies, ... Protection System and implement it. ... the uber-fast guys do the designing. ... The problem with the two main evil overlords is that they've been ...
    (rec.arts.sf.written)
  • Re: Excel 2007: Macros disabled when workbook is protected (why?)
    ... use the new zipped xml format with protected sheets/workbooks. ... encrypted macros so Excel will not enable them. ... sheet/workbook protection as older versions that is so easy to break with a ...
    (microsoft.public.excel.programming)
  • Re: File gets password added after printing...automatically
    ... happen without macros enabled (it's a company template with many macros). ... unlikely if file level pw protection is being applied. ... password protection or are the documents being set as "Read Only"? ...
    (microsoft.public.word.docmanagement)
  • Re: key behavior
    ... which are required in the form template and the template must be left ... The auto macros set the protection having fulfileld their ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.vba.beginners)