View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J. Andrew Smith J. Andrew Smith is offline
external usenet poster
 
Posts: 5
Default 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