I am not aware of a way to prevent multiple selections except through code,
so you will have to modify your existing code or add event code (assuming
you are doing that now with your existing code) to prevent this. Besides, I
doubt whether you would really want to globally restrict multiple
selections. What if the user needed to delete several rows of data for some
reason (or any other scenario involving multiple cells that doesn't deal
directly with your VB code)... would you really want the user to have to
delete each cell's content manually, one cell at a time?

--
Rick (MVP - Excel)


"egun" wrote in message
...
Does anyone know how to prevent multiple selections on a worksheet? I
just
finished putting together some VBA modules that are working very well,
when I
realized that if the user makes multiple selections (using the control
key),
then my VBA will break.

I would rather not update the code, and in fact the user should never make
multiple selections with this particular tool. I would rather just
prevent
them, if possilble.

Thanks in advance,

Eric