I created a trending tool using excel scripts and drop down menu. Most of my
colleagues using my tool were able to click on the drop drown menu and run
the scripts, except one person. I set his excel macro security to the lowest
level, but he still can't click on the drop down menu. Please let me know if
their is something that I need to set on his excel. We all use Microsoft
Office Professional Edition 2003.

One thing to try while we wait for one of the gurus to respond:

On a machine that works as expected, on the Excel menu click Tools
AddIns and note which boxes are checked. On the machine that is not
working as expected, make sure those same AddIns are selected.

Dave O
Eschew Obfuscation