MACRO- Protecting a form

Question

I recently created a template with macros. I Created a fill-able form  word template that opens a new document every-time it open. I want to protect my template so no one can edit it.  but for some reason i am not able to  do so. I am having trouble with the macro and the protecting form

How can i add protection to the document and to the macro so there is no error??

Sub AutoNew()

Order = System.PrivateProfileString("C:\Settings.Txt", _

        "MacroSettings", "Order")

If Order = "" Then

    Order = 1

Else

    Order = Order + 1

End If

System.PrivateProfileString("C:\Settings.txt", "MacroSettings", _

        "Order") = Order

ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")

ActiveDocument.SaveAs FileName:="S:\DBS\ACSkyways work order\work order" & Format(Order, "00#")

End Sub

please help!!

Answer 1

Further to Jay's response, if you insert a { Docvariable Order } in place of the bookmark and then replace

ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")

ActiveDocument.SaveAs FileName:="S:\DBS\ACSkyways work order\work order" & Format(Order, "00#")

by

With ActiveDocument

   .Variables("Order").Value = Format(Order, "00#")

   .PrintPreview

   .ClosePrintPreview   .SaveAs FileName:="S:\DBS\ACSkyways work order\work order" & Format(Order, "00#")

End With

you can then apply the protection to the template itself, rather than using code to do it.

Answer 2

Between the ActiveDocument.Bookmarks statement and the ActiveDocument.SaveAs statement, insert this statement:

ActiveDocument.Protect Type:=wdAllowOnlyFormFields, Password:=""

If you want to have a password that's required to turn off the protection, include it between the quote marks.

Note that the template should not be protected for forms, because that would prevent the insertion of the order number at the bookmark. The protection must be turned on after that insertion, but before the document is saved.