Macrobutton shifts view when document is protected for forms

Cosmo · #1 10-15-2013, 10:17 AM

Quote:

Originally Posted by Charles Kenyon

When a user clicks anywhere in a document protected for forms (other than in an active formfield) the focus moves to a page with formfields that are active.

Assuming you are using legacy form fields, you can designate a macro to run on exit from a formfield.

You can put the following in an AutoOpen and AutoNew macro in your form template:

Code:

Sub AutoOpen()
' Set macro button response to one click rather than double-click
' Macro written by Charles Kenyon based on help from Bill Coan on newsgroup
'
   Options.ButtonFieldClicks = 1
'
End Sub

This makes a single click activate the macrobutton.

Making Forms with Microsoft Word

Thanks, I'll look into that.

According to the help files for the 'Options' object:

Quote:

Represents application and document options in Word. Many of the properties for the Options object correspond to items in the Options dialog box.

Is the ButtonFieldClicks an application-level setting? Do I need to reset it after my form is completed? Is this an option available in the UI?

I'm assuming there's no way to set this for the document so that it travels with the document without scripting.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable Protected View in Microsoft Excel	kwon34	Excel	2	09-27-2013 08:38 PM
Cannot open emailed documents in Word 2010 - Protected View	Andrewjmarino	Word	8	09-05-2013 03:58 PM
Spell checker in Word protected forms	Frankwlc	Word	3	08-02-2013 12:15 PM
Using bookmarks in a protected document	Bill Stemp	Word	0	10-16-2010 06:47 AM
MacroButton	MednataMiza	Word	0	06-29-2010 01:59 AM