I want to set a choices in several cells that have drop down lists to one
value each time I open the worksheet (or if I have been doing "what if"
scenarios).

Lets say I have 3 cells that have 5 choices each A1, A2, and A3

In B1, B2, B3 have values inserted based on the drop down choices in column A

One of those choices in A for all 3 cells is "No choice", with a 0 value in
column B if that choice is taken.

I want to perform a macro that goes in and chooses "No choice" automatically
when the macro is run. I have been unsuccessful, it doesn't do anything with
the drop down lists (I have other cells that the macro does change correctly,
just not the choices in the ddl)

How can I get around this?

Many many thanks!