Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 11-14-2012, 06:04 PM
macropod's Avatar
macropod macropod is offline Drop-Downs:  Run Macro on Exit Windows 7 64bit Drop-Downs:  Run Macro on Exit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Andrew H View Post
I am having all sorts of problems getting a macro to run "on exit" from a drop-down list.

I think there is a fundamental issue that I need some help on. In order for a drop-down list to be "active", the document must be in a protected state. So I ensure my document is in a protected state when the document is provided to a user (who will use the drop-down). Fine.


Now suppose I want the macro to insert text "on exit". Well, presumably I have to unprotect the document to do this.
There's a couple of issues to consider here.

First, you don't necessarily need a macro to conditionally display some text in the document. This could be done via field coding, with the formfield's 'calculate on exit' option checked. See, for example: https://www.msofficeforums.com/word-...html#post38948

Second, if the text is to be put into another formfield, or an unprotected Section of the document, there is no need to unprotect the document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop-Downs:  Run Macro on Exit Fire drop down Macro on change carlosriver24 Word 1 08-02-2012 07:18 PM
Drop-Downs:  Run Macro on Exit Macro ? - Checkbox in Word + drop down selection help dice1976 Word 4 07-24-2012 11:18 AM
Drop-Downs:  Run Macro on Exit Drag and drop macro Amanoo PowerPoint 2 06-15-2012 04:01 AM
Drop and drag macro Jamtart PowerPoint 3 04-15-2012 11:05 PM
Drop-Downs:  Run Macro on Exit Please help me with drop downs in Excel 2010 mhays Excel 6 01-16-2012 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 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