J
J. Andrew Smith
I have a macro that asks two yes-no questions to start. I generally answer
them yes and no by hitting Y-N very quickly. Sometimes I'm so quick that the
N goes into the currently selected cell, where Excel thinks I'm entering a
string. When I hit Escape, the macro stops, and the N is still there.
How do you get a macro to ignore all user input unless and until a message
or input box comes up?
them yes and no by hitting Y-N very quickly. Sometimes I'm so quick that the
N goes into the currently selected cell, where Excel thinks I'm entering a
string. When I hit Escape, the macro stops, and the N is still there.
How do you get a macro to ignore all user input unless and until a message
or input box comes up?