Summary: 2 page document with two continuous section breaks. One located at the bottom of page 1 and the other at the bottom of page 2. AutoNew macro which protects page 1 and leaves page 2 unprotect (works fine). Page 1 is a large table with form fields. Page 2 contains a bookmark where the narrative will start. The last form field on Page 1 contains an on exit macro to go to the bookmark on page 2.
Off The Record | Anonymous | InfoWorld::
It gives up some form of control. In our case we gave up the control of And totally unprotected. I know it was naughty of me, but I couldn't resist.
http://weblog.infoworld.com/offtherecord/HOME |
T E A M F L Y::
File Format: PDF/Adobe Acrobat6.4 Exiting a Procedure. VBA provides the. Exit Sub. and. Exit Function argument for a sheet that is password-protected, Excel will prompt the user
http://agemame.fruit-emu.com/resources/doc/OReilly - Writing Excel Macros with VBA, 2nd Edition Ebook -fly.pdfHOME |
Goal #1: To get the cursor from the last form field on page 1 to the narrative bookmark on page 2.
Goal #2: Leave Page 1 protected via the section break and page 2 unprotected just as the document opened via the AutoNew macro.
Issues: Using numerous variations of the below code, the only thing that happens is the cursor does actually exit the last form field (via the exit macro) but only goes to the bottom of page 1 at the section break and never makes it to the bookmark. In view mode
FileMaker::
File Format: PDF/Adobe AcrobatFileMaker Pro provides three views of each layout: form, list and Only the data in fields is protected with passwords. Table and
http://www.filemaker.com/downloads/pdf/fmp_6_UG.pdfHOME |
ActiveDocument.Unprotect
ActiveDocument.Sections(1).ProtectedForForms = False
If ActiveDocument.Bookmarks.Exists("swPropNarr") Then
ActiveDocument.Bookmarks("swPropNarr").Select
End If
FYI: If I run the macro while the document is unprotected, it works perfect.
The macro must be called from within another macro. Don't ask me why but that is the only way it will work:
Microsoft Word Document Management - Page 46::
Limiting number of lines of unprotected text in a document · Hyperlink to web page .. Can names be merged to a form and still have other fields active?
http://www.pcreview.co.uk/forums/archive/forum-190-46.phpHOME |
Sub macGoToBMPropNarr()
Application.OnTime When:=Now, Name:="ReallymacGoToBMPropNarr"
End Sub
-----------------------------------------------------------
Sub ReallymacGoToBMPropNarr()
If ActiveDocument.Bookmarks.Exists("swPropNarr") Then
ActiveDocument.Bookmarks("swPropNarr").Select
End If
End Sub
Thanks to: microsoft.public.word.vba.general
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
HOME
PRINT
Add to favorites