If I was to put the macro "On entry" once the macro runs if the user changes the drop down to another comment to have the macro re-run? I think maybe that was the question I should have asked.
When I do this now it seems like the macro will only run once?
|