![]() |
|
#1
|
|||
|
|||
|
It appears that a macro that I have set up to run "on exit" from a drop-down list is not executing. At present, I am simply interested in learning how to get any macro to run on exit. Here is the macro that I have set up to run on exit: Sub PrintTextonSelection() ActiveDocument.Unprotect Dim MyText As String MyText = "I made a selection" Selection.TypeText (MyText) End Sub To test, I first protected the file (in order to allow use of the drop-down) and then made a selection. Result: the "I made a selection" text was not inserted nor did the document transition to an unprotected state. I am a complete novice re VBA and macros. Any suggestions welcomed. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Fire drop down Macro on change
|
carlosriver24 | Word | 1 | 08-02-2012 07:18 PM |
Macro ? - Checkbox in Word + drop down selection help
|
dice1976 | Word | 4 | 07-24-2012 11:18 AM |
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 |
Please help me with drop downs in Excel 2010
|
mhays | Excel | 6 | 01-16-2012 09:29 AM |