Hi,

I am trying to do the same thing with my drop down list. I get my macro
to run using the shortcut key, but when I select a item from my drop
down, it does  not take me to another worksheet within my book. The
code is exactly the same, can you help me with this problem.

Adrianne