I have a new question for you. Is there any way, in your example, to add to the macro that changing cell A1 to a value OTHER than "run" will cause another action to take place (for example, return a default text value or clear the cell). I'm not sure how to trigger that... perhaps an "else" type line?
I'm obviously not the best VBA guy, but I'm learning! :wink2: