I have a drop down box (created using data validation). I have a macro that takes me to a sheet with this drop down box on.
If I make a selection from the drop down box and move away from that sheet, then run the macro to take me back to that sheet, the drop down box still shows my previous selection. Instead, every time I go back to that sheet, I want the drop down box to display the top selection (which will be something like "make a selection") instead of my last chosen selection.
Does anyone know how to do this?
Thanks
Bookmarks