Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-15-2013, 09:34 AM
Charles Kenyon Charles Kenyon is offline Macrobutton shifts view when document is protected for forms Windows Vista Macrobutton shifts view when document is protected for forms Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,582
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macrobutton shifts view when document is protected for forms Disable Protected View in Microsoft Excel kwon34 Excel 2 09-27-2013 08:38 PM
Macrobutton shifts view when document is protected for forms Cannot open emailed documents in Word 2010 - Protected View Andrewjmarino Word 8 09-05-2013 03:58 PM
Macrobutton shifts view when document is protected for forms 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft