Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-13-2012, 04:20 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


In Word 2003, the equivalent is Tools|Macro|Security > Medium. Do be aware that you need to open the document after chnaging this setting. Also, if you've saved the attachment since downloading it, Word may have deleted the macro because of the previous settings.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 11-14-2012, 08:13 AM
Andrew H Andrew H is offline Drop-Downs:  Run Macro on Exit Windows 7 32bit Drop-Downs:  Run Macro on Exit Office 2010 32bit
Advanced Beginner
Drop-Downs:  Run Macro on Exit
 
Join Date: Nov 2012
Location: Montreal, Quebec
Posts: 51
Andrew H is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
In Word 2003, the equivalent is Tools|Macro|Security > Medium. Do be aware that you need to open the document after chnaging this setting. Also, if you've saved the attachment since downloading it, Word may have deleted the macro because of the previous settings.
Thanks for all you advice, but still no success.
Reply With Quote
  #3  
Old 11-14-2012, 12:55 PM
Andrew H Andrew H is offline Drop-Downs:  Run Macro on Exit Windows 7 32bit Drop-Downs:  Run Macro on Exit Office 2010 32bit
Advanced Beginner
Drop-Downs:  Run Macro on Exit
 
Join Date: Nov 2012
Location: Montreal, Quebec
Posts: 51
Andrew H is on a distinguished road
Default

I am really quite mystified. I created a macro that unprotects a document. And I know that it works - I tested by assigning the macro to a key, protecting the document, and then activating the key. Sure enough, the document transitions to an unprotected state.

But when I assign that very same macro to fire "on exit" from a drop-down, it does not work. And I have figured out (through "debugging") that the macro does not fire when the user makes a selection from the drop-down.

Can anyone explain to me what specific event constitutes "exiting" a drop-down? I had assumed that the selection of some item from the list via the mouse constitutes the "exit" event. Is that correct?

Last edited by Andrew H; 11-14-2012 at 02:33 PM.
Reply With Quote
Reply



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 08:50 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