I'm building a spreadsheet from within Access/VBA. I export my data into a
spreadsheet template, format some of the cells, unlock others, protect the
sheet then save it with a unique name (and later email it). I'm doing fine up
till this point: using Access/VBA I want to set up some of the cells to only
accept input from a drop down. There will only be 2 allowable values and, as
these worksheets are going to end-users, I'm trying to keep as much of the
complexity as possible within Access.

Any ideas? TIA......