That warning is only for drag and drop operations. With the option selected
make an entry in A1 and in A2. Drag A1 on top of A2. You should get a
warning.

--
Jim Rech
Excel MVP
"Keith bedford" wrote in message
...
|I cannot seem to get the "Alert Before Overwriting Cells" option to work.
| Although I have the box checked I can overwrite non-empty cells without a
| message. Can someone please help???