How to ignore user input during macro execution?
 

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?

--
J. Andrew Smith
Senior Systems Analyst
Standard & Poor''s, NYC

How to ignore user input during macro execution?
 

Hi,

Can we see the part of the macro that accepts this input?

Mike

"J. Andrew Smith" wrote:

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?

--
J. Andrew Smith
Senior Systems Analyst
Standard & Poor''s, NYC