Hi Folks,

I am not a VBA programmer but I am using VBA with WORD 2007. I created a template/form to capture input from users. The form consists of a table from which the user inputs specific data elements, and a free format area where the user authors an assessment.

I put a macro in one of the drop down boxes in the table to execute on exit. That macro should place the cursor at the end of the document. The end of the document should be immediately following the word "Assessment:" which follows the table... When I test the macro with the template unprotected, it works as expected and places the cursor right after the word "Assessment".

However, when I protect the template and execute it .. the cursor ends up directly after the table that is above the word "Assessment:". No warnings or errors from VBA or WORD, it just dumps the cursor "early".

Any guidance you can provide would be appreciated. If you require compensation for your time and efforts please let me know your scale.

Thanks much.

Fergie

Hi

If the document is protected and your end of document cannot be edited, the cursor will not move there.

I am not sure about the code you have. Here is a hint if you want to move to EOD

Selection.GoTo wdGoToBookmark, , , "\EndOfDoc"

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

I can accept your premise at face value, but as I mentioned, the cursor does move to the end of the file before I protect the document. But only to the end of the table after protecting it.

I suppose I could have the macro unprotect the file before executing the command to go to the end...

I do not fully understand your sample code. I do not have a bookmark defined for EndOfDoc. I will research on that idea though.

Thanks for the feedback.

Fergie

Hi

\EndOfDoc is a predefined bookmark in Word. This resides at the End of the document

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Roger that... Thank you!

Ferg