How to ignore user input during macro execution?

  • Thread starter J. Andrew Smith
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top