Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a macro to data sort in a table within a protecte.
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Thank you very much - looks like it will do the trick. Cheers
"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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
Graham - as I should have earlier, I have moved my enquiry over to the
programming discussion. Thanks again for your assistance. Cheers. |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table in a Form | Tables | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
How do I insert Excel data as a Word table and stay within margins | Tables | |||
Can't sort table alphabetically | Microsoft Word Help | |||
Word 2003 Table AutoFormat vs Macro vs VBA | Tables |