View Single Post
  #6   Report Post  
Graham Mayor
 
Posts: n/a
Default

The methodology is explained at
http://word.mvps.org/faqs/macrosvba/...ProtectDoc.htm. There is also
code on the MVPS web site which will help you fire an action based on the
result of a checkbox field.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Keenly52 wrote:
Graham - I hate to impose but I ran into a couple of snags - btw it's
Office 2003.

VB didn't recognize the variable bProtected (I never got past the 2nd
line). Only certain sections are protected
I need to password the protection and the code

Also, while I have you - is there any way a Macro can look at the
value of a Form field check box and then trigger certain actions
depending on that value? Or would I require a Control check box for
that? If you had sample code that would be awesome.

Many thanks again. Ken.

"Graham Mayor" wrote:

Try the following

'Unprotect the file
If ActiveDocument.ProtectionType wdNoProtection Then
bProtected = True
ActiveDocument.Unprotect
End If

Put your code here

'Reprotect the document.
If bProtected = True Then
ActiveDocument.Protect _
Type:=wdAllowOnlyFormFields, NoReset:=True
End If


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





Keenly52 wrote:
I'm creating a user form in Word that includes a table to be sorted
afterthe user enters their info - specifically a sort on the "date"
column.

The macro I created works fine in an unprotected doc, but not when
it's protected - which it will always be when being used by others.

I can't find a Word command to include in the macro unprotect the
doc or the selection ('ProtectedForForms = False' doesn't work in
Word) ... I can't create a macro in a protected document (I don't
think), and when clicking on "Protect Document" the macro stops
recording.

Any help with a solution is greatly appreciated. Thanks.