Hi Col,

First up I know nothing about Visual Basic so I may be a long
way off here but I imagine that your routine would be calling
up Data Validation to do this.

So maybe look through your routine for a reference to data validation
and try playing with the settings in the routine.

Just a guess
Martin