I have built macros which are activated by a single cell selection in a worksheet (using a change event macro). I get an error if the user inadvertently selects more than one cell. My questions a

1. How can I prevent the user from selecting more than one cell on a particular worksheet?

2. What code will abort a macro if there is an error.

Many Thanks

Michael