There is nothing wrong with the macro, as such. Without knowing how you're using your dropdown menu, though, it's impossible to say what the issue is. If you're referring to a dropdown formfield, the only macro one of those can run is the one specified in it's properties as the 'exit' macro. your macro security settings would also have to allow macros to run.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I can run the macro just fine by clicking "Macros -> Run MyMacro".

I'm using a legacy drop down field. I right clicked it and selected MyMacro in the "Exit" field. I protect the document to "Filling in forms" so I can start using the drop down. Then I select a value from the drop down menu but nothing happens.