Tracking Changes and protect section of a document on Save

[shaleen7]

I'm trying to do two things:
Turn on the tracking changes option and protect 2 section of my form when it is saved.

Any suggestions, thanks.

 

[Dreamboat]

What's the problem?
You mean you want to do this with VBA or...?

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[shaleen7]

VBA.

 

[Dreamboat]

Version of Word, please?
Also, have the form fields been populated, and what sections?

Have you tried recording the macro?

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[shaleen7]

Word 2000 and sections 2 and 4. I tried using the macro recorder but I keep getting an autoexec error.

 

[Dreamboat]

What's the error?
Are you putting this in an auto_exec macro?

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com

 

[shaleen7]

I told that was the best place to put it but I think from what I've read it should be okay to place a regular macro in the template. Unforunately I'm not VBA literate.

 

[fumei]

Yes, please give more details. There may be a problem here. Word seeems to allow revision to override form protection. You can, by code, protect for both. However, trached changes is global - that is, it can NOT be restricted to sections. At least i have not be able to do so yet. Therefore, even though you protect specific sections for forms, if you have the document allows revisions...well that overrides form protection, and you can do whatever you like, and even though the form sections show as protected, the forms do not work.

Interesting.



Gerry

 

[shaleen7]

I'm trying to enable "protect document" on 2 sections of my word document, section 2 and 4 because sections 2 and 4 contain my check boxes. I also need to enable track the changes on the word document once the user saves the form.

Is there anyway to accomplish both?

 

[shaleen7]

What if instead of using the check box feature I have the user place the letter X in each word table cell. This way I could turn on the track canges feature and I wouldn't need to protect the form for the checkbox fields.

The only thing is I have to keep a count similiar to the checkbox example. I need to keep track of the number of x's the placed in each cell.

How would I accomplish this?

 

[fumei]

Just want to make sure I completely understand.

The user will check some checkboxes thast are in Section 2 and 4. Section 1 and 3 (and 5... if they exist) are not protected as there are no forms.

OK, I think I have that. What I want to clarify is the following:

need to enable track the changes on the word document once the user saves the form

once the saves the form - this implies you want to be able to track changes they makes AFTER they have saved, and closed it, then reopened it? Changes they make after they save it, and they save it again but before they close it?

1. Do you need to track if the user has changed the checkbox? That is, do you need to track if they UNchecked it later?

2. Do you mean to allow them to do that?

3. Do you only want to track changes in Section 1 and 3?

There is likely a good solution to this. Just a few more etails and we'll be there.



Gerry

 

[shaleen7]

Answers questions:
Once the saves the form - this implies you want to be able to track changes they makes AFTER they have saved, and closed it, then reopened it? Changes they make after they save it, and they save it again but before they close it? Yes.


1. Do you need to track if the user has changed the checkbox? That is, do you need to track if they UNchecked it later? No, I don't need to.

2. Do you mean to allow them to do that? No but if it has to be done they I can live with it.
3. Do you only want to track changes in Section 1 and 3? Yes

Thanks.