Sorting in a protected document?

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I have a table where in one of the columns, I have a drop
down menu. Therefore in order to activate it, I have to
protect my document.

However, in another column, I have numbers which need to
sort my table by priorities periodically. If the document
is protected, it will not give me the option to sort.

Is there a way to bypass this?
 
Hi, Diane,

You need to unprotect the document, sort, and reprotect without
resetting the fields. This is similar to the task done by the macro in
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm --
replace the spellchecking code there with sorting code. If you need
help with that, please come back and say which column contains the
numbers to sort.
 
Sorting in Protected documents

Hi,

I have a similar problem. I created a table with drop down Menus, and I want to be able to "sort the dates" in the left column in ascending order. I would like this to happen automatically, even after people type their entries in. Remember, the document is still protected.

For example...(table looks as follows)
Line 1: 6/12/05*drop down here*text here*drop down here
Line 2: 6/13/05*drop down here*text here*drop down here
Line 3: 6/10/05*drop down here*text here*drop down here

I would like to have the final output to look like this:
Line 1: 6/10/05*drop down here*text here*drop down here
Line 2: 6/12/05*drop down here*text here*drop down here
Line 3: 6/13/05*drop down here*text here*drop down here

Is this possible? Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top