| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort a table in an unprotected section of a protected document
I would like to use the sort function in a table that is in an unprotected
section of a document protected for forms. When the document is protected, however, the sort function on the tables menu is greyed out even when my cursor is in the unprotected section. Is there any way around this? I am using Word 2002 and Windows 2000. -- Thanks, Jenny |
|
#2
|
|||
|
|||
|
Use the following code in a macro
ActiveDocument.Unprotect If Selection.Information(wdWithInTable) = True Then Dialogs(wdDialogTableSort).Show End If ActiveDocument.Protect wdAllowOnlyFormFields, NoReset -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... I would like to use the sort function in a table that is in an unprotected section of a document protected for forms. When the document is protected, however, the sort function on the tables menu is greyed out even when my cursor is in the unprotected section. Is there any way around this? I am using Word 2002 and Windows 2000. -- Thanks, Jenny |
|
#3
|
|||
|
|||
|
Forgive my lack of knowledge on this. I have created the macro, but now am
unable to protect the document. What am I doing wrong? -- Thanks so much for your reply. Am very grateful for the help! Jenny "Doug Robbins" wrote: Use the following code in a macro ActiveDocument.Unprotect If Selection.Information(wdWithInTable) = True Then Dialogs(wdDialogTableSort).Show End If ActiveDocument.Protect wdAllowOnlyFormFields, NoReset -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... I would like to use the sort function in a table that is in an unprotected section of a document protected for forms. When the document is protected, however, the sort function on the tables menu is greyed out even when my cursor is in the unprotected section. Is there any way around this? I am using Word 2002 and Windows 2000. -- Thanks, Jenny |
|
#4
|
|||
|
|||
|
The document will need to be protected when the macro is run. To be able to
run a macro in a protected document, the macro will need to either be called On exit from a formfield, be assigned to the keyboard or assigned to a toolbar button. See section 3 of the article at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... Forgive my lack of knowledge on this. I have created the macro, but now am unable to protect the document. What am I doing wrong? -- Thanks so much for your reply. Am very grateful for the help! Jenny "Doug Robbins" wrote: Use the following code in a macro ActiveDocument.Unprotect If Selection.Information(wdWithInTable) = True Then Dialogs(wdDialogTableSort).Show End If ActiveDocument.Protect wdAllowOnlyFormFields, NoReset -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... I would like to use the sort function in a table that is in an unprotected section of a document protected for forms. When the document is protected, however, the sort function on the tables menu is greyed out even when my cursor is in the unprotected section. Is there any way around this? I am using Word 2002 and Windows 2000. -- Thanks, Jenny |
|
#5
|
|||
|
|||
|
Doug - This is fantastic. The document doesn't lend itself to the macro
being assigned to the keyboard or run upon exit from a field, but assigning a toolbar button is perfect. Works like a charm. Thanks again for your help. So glad to have found this resource! Jenny "Doug Robbins" wrote: The document will need to be protected when the macro is run. To be able to run a macro in a protected document, the macro will need to either be called On exit from a formfield, be assigned to the keyboard or assigned to a toolbar button. See section 3 of the article at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... Forgive my lack of knowledge on this. I have created the macro, but now am unable to protect the document. What am I doing wrong? -- Thanks so much for your reply. Am very grateful for the help! Jenny "Doug Robbins" wrote: Use the following code in a macro ActiveDocument.Unprotect If Selection.Information(wdWithInTable) = True Then Dialogs(wdDialogTableSort).Show End If ActiveDocument.Protect wdAllowOnlyFormFields, NoReset -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jenny E" wrote in message ... I would like to use the sort function in a table that is in an unprotected section of a document protected for forms. When the document is protected, however, the sort function on the tables menu is greyed out even when my cursor is in the unprotected section. Is there any way around this? I am using Word 2002 and Windows 2000. -- Thanks, Jenny |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shading tables in unprotected section of a protected form | Microsoft Word Help | |||
| Table headers/footers and layout | Page Layout | |||
| Table AutoFormats vs. Table Styles confusion | Tables | |||
| Table Sort - Sort only 3 of 4 columns | Microsoft Word Help | |||
| Can't sort table alphabetically | Microsoft Word Help | |||
Linear Mode
